Use array or a different table?
Hey guys, i want to know your opinion about this, i have a table of users, every users can be...
Top PostgreSQL News
Category Added in a WPeMatico Campaign
Pointing to remote servers
I have a postgres database on server A, clients on server B don't know about A, and the command line...
oracle to postgres blob to clob
dbms_lob.createTemporary(lob_loc => l_clob, cache => false); dbms_lob.converttoclob(dest_lob => l_clob, src_blob => p_blob, amount => dbms_lob.lobmaxsize, dest_offset => l_dest_offsset, src_offset =>...
What is the best way to delete entries from one table on basis of duplication in its foreign dependency table?
Hi, I have two tables with the structure and sample data like - Table mapping - id | user_id |...
Christophe Pettus: The importance of max_wal_size
The reality is that most PostgreSQL configuration parameters don’t have a huge impact on overall system performance. There are, however,...
Michael Paquier: Postgres 16 highlight – More patterns for pg_ident.conf
The second phase of the improvements done in PostgreSQL 16 for authentication configuration involve pg_ident.conf, mainly with this commit: commit:...
PostgreSQL Arithmetic Operators
In PostgreSQL, we can easily perform operations such as addition, subtraction, division, multiplication, square root or factorial between numbers or...
Postgres Raster Query Basics
submitted by /u/mmaksimovic Go to Source of this post Author Of this post: /u/mmaksimovic Title Of post: Postgres Raster Query...
exclude using gist from another table?
I have a users, reservations table, and a reservations_users table, I'm using uuid-ossp and btree_gist extenstions on postgres 14. I...
do i have to manual tell my db what the pk and fks are?
i am making a db and am creating a table from a csv file. when writing my column names i...
