User dwhitemv

9 votes

What does it mean that PostgreSQL "offers" PHP?

answered Oct 5, 2021 at 4:29

5 votes

Accepted

Concurrent update on two different tables fail

answered Oct 13, 2022 at 4:39

4 votes

Accepted

\dt says "Did not find any relations."

answered Oct 15, 2021 at 4:09

3 votes

Accepted

Postgres RLS: how to error instead of ignoring rows not matched by the policy?

answered Oct 7, 2021 at 2:20

3 votes

Accepted

PLPGSQL store columns of a 2D query output into array variables

answered Sep 21, 2021 at 20:16

3 votes

Accepted

Using the same SELECT statement in two different DELETE statements

answered Nov 22, 2022 at 22:19

3 votes

Accepted

Postgres sort results by id's from subquery

answered Nov 25, 2022 at 7:10

2 votes

Accepted

How to prevent what looks like PostgreSQL faulty optimization inside a function?

answered Nov 12, 2022 at 16:02

2 votes

Upsert always updates postgreSQL

answered Nov 13, 2022 at 20:17

2 votes

How does Postgresql handle disk-free spacing?

answered Nov 15, 2022 at 1:38

2 votes

Alter a function in Postgres 12 to allow for dates to be default or populated

answered Nov 17, 2022 at 16:04

2 votes

Improving query (Doing a nasty self join on a range with ctes)

answered Oct 6, 2021 at 20:59

2 votes

Check if running inside a PostgreSQL extension setup/upgrade script

answered Nov 21, 2022 at 3:16

2 votes

what is best way to handle history tables in postgresql?

answered Aug 29, 2021 at 2:09

2 votes

Accepted

Joining historical data in postgres

answered Sep 8, 2021 at 1:23

2 votes

Accepted

Postgresql - How to interpret backup_label contents?

answered Sep 11, 2021 at 5:22

2 votes

Accepted

In PostgreSQL how do I generate a script that will recreate the database and all of its contents?

answered Oct 8, 2022 at 3:45

2 votes

exclusiveness of multiple table locks for a single transaction

answered Oct 11, 2022 at 18:01

2 votes

Accepted

Postgresql: database migrations refused because the database user is not table owner but is the database owner

answered Oct 16, 2022 at 2:16

1 vote

Accepted

Should i put composite key columns next to each other?

answered Oct 23, 2022 at 19:13

1 vote

Accepted

PostgreSQL INSERT Multi-Dimensional Array

answered Oct 13, 2022 at 19:44

1 vote

Calculate Percentage for Values Exist in Only One or Both Tables

answered Oct 9, 2021 at 6:43

1 vote

PostgreSQL user mapping not working between AD user and DB user

answered Oct 26, 2021 at 20:01

1 vote

Accepted

How do you run "SELECT" on the composite type argument of an SQL function?

answered Sep 27, 2022 at 17:55

1 vote

Track row affected by a plpgSQL's DML from Python code block

answered Sep 27, 2022 at 20:57

1 vote

Accepted

Postgresql: 'upserting' into two tables (vertical partitioning) using the same id with a unique constraint

answered Sep 13, 2021 at 20:21

1 vote

Implementing revisioning logic with SCD2/4

answered Sep 7, 2021 at 1:59

1 vote

How to index when partitioning for start and stop time columns in PostgreSql 12

answered Sep 21, 2021 at 21:22

1 vote

How to select the latest continuous set of rows of a certain type?

answered Oct 5, 2021 at 6:01

1 vote

Class Table Inheritance combined with running searches and paging

answered Oct 6, 2021 at 16:27

Stack Exchange Network

78 Answers

What does it mean that PostgreSQL "offers" PHP?

Concurrent update on two different tables fail

\dt says "Did not find any relations."

Postgres RLS: how to error instead of ignoring rows not matched by the policy?

PLPGSQL store columns of a 2D query output into array variables

Using the same SELECT statement in two different DELETE statements

Postgres sort results by id's from subquery

How to prevent what looks like PostgreSQL faulty optimization inside a function?

Upsert always updates postgreSQL

How does Postgresql handle disk-free spacing?

Alter a function in Postgres 12 to allow for dates to be default or populated

Improving query (Doing a nasty self join on a range with ctes)

Check if running inside a PostgreSQL extension setup/upgrade script

what is best way to handle history tables in postgresql?

Joining historical data in postgres

Postgresql - How to interpret backup_label contents?

In PostgreSQL how do I generate a script that will recreate the database and all of its contents?

exclusiveness of multiple table locks for a single transaction

Postgresql: database migrations refused because the database user is not table owner but is the database owner

Should i put composite key columns next to each other?

PostgreSQL INSERT Multi-Dimensional Array

Calculate Percentage for Values Exist in Only One or Both Tables

PostgreSQL user mapping not working between AD user and DB user

How do you run "SELECT" on the composite type argument of an SQL function?

Track row affected by a plpgSQL's DML from Python code block

Postgresql: 'upserting' into two tables (vertical partitioning) using the same id with a unique constraint

Implementing revisioning logic with SCD2/4

How to index when partitioning for start and stop time columns in PostgreSql 12

How to select the latest continuous set of rows of a certain type?

Class Table Inheritance combined with running searches and paging