I got a files table: CREATE TABLE files ( id SERIAL PRIMARY KEY, path VARCHAR NOT NULL UNIQUE ); And I wanna write an sql transaction to emulate FS behavior when you tryna create a file: if a file with…
I use psql to connect to multiple databases which contain multiple schemas. I usually use just one schema per db. Is it possible to set the default schema for a particular db via some psql config option or envariable?
We have a postgres database table where every second 50 rows will be added to that table continously from a realtime application. Now we have read every newly added row(one row at a time) using python script. Is it possible…
I have a table with the lat & lng for two points: CREATE TABLE location_pairs ( lat_1 float, lng_1 float, lat_2 float, lng_2 float ); I also have a function that takes two lat/lng coordinates pairs and returns a table…
I'm follow up with this repo and try to connect psql from my local machine to Postgresql on docker image after running docker compose up -d but I got this error I tried with adminer portal that come along with…
Unlike most SQL derivatives, PostgreSQL doesn't use the traditional DESCRIBE TABLE foo syntax; it uses d foo (from the psql interpreter). That's great, except that (especially when I have psql open in a terminal with limited width) it can be…
I am trying to get a single row for each group by clause in the query. Each SELECT output has a json in it. I am trying this: SELECT MIN(C.json_column->'key') AS Key, A.field1, B.field2 FROM json_table AS C LEFT JOIN…
I have a user defined Postgres function that does dynamic insert. Code is unread-able and it's quite hard to modify it due to string escapes. Is there a way to make it look better? Here my code, some parts omitted…
We need to order a list of room numbers. You can think of the units being numerically ordered, with the possibility of a letter in front as a prefix, e.g 1, 2, 3, 4, 5, 6, 7, 8, 9, 10,…
I have a set of data that I group by "product_group_id", "group_name" and "class". Names of products for this group are different. CREATE TABLE rule ( product_id integer , product_group_id integer , group_name text , class text , name text…