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 in multiple categories (max 5 categories), should i make a…
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 psql knows how to get to A without user intervention.…
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 => l_src_offsset, blob_csid => dbms_lob.default_csid, lang_context => l_lang_context, warning => l_warning);…
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 | role_id 1 | 5 | 3 2 | 5 |…
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, a couple that really can make a huge difference when…
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: efb6f4a4f9b627b9447f5cd8e955d43a7066c30c author: Michael Paquier <michael@paquier.xyz> date: Fri, 20 Jan 2023…
PostgreSQL Arithmetic Operators
In PostgreSQL, we can easily perform operations such as addition, subtraction, division, multiplication, square root or factorial between numbers or two columns. Operator Icons Let’s make an example using some…
Postgres Raster Query Basics
submitted by /u/mmaksimovic [link] [comments] Go to Source of this post Author Of this post: /u/mmaksimovic Title Of post: Postgres Raster Query Basics Author Link: {authorlink}
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 want multiple users to be a part of a reservation,…
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 see a PK toggle. do i have to select that…