Say I have a table called list, where there are items like these (the ids are random uuids): id rank text --- ----- ----- x 0 Hello x 1 World x
I have transaction with several queries. First, a select rows with FOR UPDATE lock: SELECT f.source_id FROM files AS f WHERE f.component_id = $1 AND f.a
How to get max_value and min_value Postgres sequence? I created the sequence using this statement create sequence seqtest increment 1 minvalue 0 maxvalue 20;
We're currently struggling with moving our Aurora Database to an RDS Postgres DB. Our database is quite huge with 80GB and some tables having up to 85 million e
I would like to select all sequences in the database, get the schema of sequence, dependent table, the schema of a table, dependent column. I've tried the follo
The table looks something like this: CREATE TABLE "audit_log" ( "id" int4 NOT NULL DEFAULT nextval('audit_log_id_seq'::regclass), "entity" varchar(50) COLLA
I have a Pandas dataframe that I'm inserting into an SQL database. I'm using Psycopg2 directly to talk to the database, not SQLAlchemy, so I can't use Pandas b
I'd like to use pg_dump to backup postgres database content. I only want to ignore one specific table containing cached data of several hundred GB. How could I
I am trying to install postgresql 9.6 using brew on my mac and get the below error whenever i start the server : FATAL: postmaster became multithreaded during
Let's say I want to write a simple SELECT query that uses a VIEW: CREATE TEMP VIEW people AS SELECT p.person_id ,p.full_name ,p.phone FROM person
Let's say I'm migrating a MySQL database to PostgreSQL with pgloader, using the default sample on the official website: load database from mysql://
Context: I have a select query where I have have link between devices. Some links have "reverse duplicates" that I would like to get rid of in the select query
When I try to test any app with command (I noticed it when I tried to deploy myproject using fabric, which uses this command): python manage.py test appname
I can't figure out what I'm doing wrong. I'm learning JPA mapping to a relational DB, by following some tutorials on the web, but can't find one that is straigh
I am not able to set Password for Postgres using Docker-compose. Postgres is loading without password and with the default user name "postgres", non of the envi
I am trying to create a list of unique patients who have left comments. The code words fine until I upload to heroku where it doesnt work in postgresql. This
All I did is in my local machine(Mac OS). After installing the postgresql, I created a user named poet with password, then created a database named poems and th
I have a Java Spring Boot app which works with a Postgres database. I want to use Docker for both of them. I initially put just the Postgres in Docker, and I ha
Let's say I have a query like so: SELECT * FROM a WHERE a.Category = 'liquid' ORDER BY a.MeasurementTime DESC; and I want to see the results coming into the da
(PostgreSQL 8.4) I got a great introduction to SQL gaps-and-islands here on Stack Overflow but I still have a question. Many island detection CTEs are based on