User tinlyx - Database Administrators Stack Exchange

68 votes

5 answers

172k views

How to create a temporary table using VALUES in PostgreSQL

asked Dec 21, 2014 at 19:44

14 votes

2 answers

22k views

How to get the schema name of a table of type regclass in PostgreSQL?

asked Mar 14, 2018 at 2:04

11 votes

1 answer

15k views

How to add a PostgreSQL 10 identity column to an existing table?

asked Feb 25, 2018 at 15:32

11 votes

2 answers

3k views

Are there standard SQL functions with side effects?

asked Feb 20, 2017 at 20:55

11 votes

1 answer

6k views

Understanding Set Returning Function (SRF) in the SELECT List

asked May 1, 2017 at 19:48

10 votes

2 answers

3k views

self-joins in recursive CTE: `recursive reference must not appear more than once`?

asked Sep 5, 2017 at 23:06

10 votes

2 answers

19k views

How to use RETURNS TABLE with an existing table in PostgreSQL?

asked Apr 15, 2016 at 3:46

8 votes

2 answers

3k views

list of PostgreSQL trusted languages?

asked Nov 29, 2016 at 8:09

8 votes

1 answer

5k views

merging many jsonb objects using aggregate functions in PostgreSQL?

asked Dec 8, 2019 at 18:14

6 votes

1 answer

13k views

How to change array_agg() to return empty array on empty input in PostgreSQL?

asked May 14, 2020 at 3:57

6 votes

1 answer

5k views

postgresql 10 for Ubuntu 17.10 artful?

asked Nov 14, 2017 at 7:56

6 votes

1 answer

4k views

disable warning from `drop table if exists`

asked Jan 29, 2019 at 9:33

5 votes

1 answer

1k views

When is the AS keyword required?

asked May 14, 2019 at 16:44

5 votes

2 answers

4k views

How to quote qualified table name with format() function?

asked Mar 16, 2018 at 0:19

5 votes

1 answer

226 views

the verbosity of "(SELECT * FROM A)"?

asked Aug 15, 2017 at 6:33

4 votes

1 answer

2k views

Why is the sum() of zero numbers not zero? [duplicate]

asked May 15, 2019 at 2:25

4 votes

5 answers

7k views

Check if two tables have the same structure (are compatible)

asked May 17, 2018 at 5:36

4 votes

2 answers

11k views

Testing if an element in a PostgreSQL array?

asked May 18, 2018 at 22:32

3 votes

1 answer

1k views

How to get the function name of a regprocedure in PostgreSQL?

asked Mar 20, 2018 at 23:36

3 votes

1 answer

6k views

how to automatically create the associated schema when I `pg_restore` a table?

asked Feb 1, 2019 at 6:39

3 votes

1 answer

215 views

How can I specify the last parameters in a function call and let the others default to the DEFAULT in the declaration?

asked May 25, 2019 at 22:15

3 votes

1 answer

677 views

Test if a string is a valid, unquoted identifier?

asked Mar 17, 2018 at 7:43

3 votes

0 answers

2k views

PostgreSQL DROP DATABASE privilege?

asked Feb 17, 2017 at 21:52

3 votes

0 answers

1k views

Unable to locate package postgresql-server-dev-15 while installing PostgreSQL 15 using pdpg?

asked Aug 28, 2022 at 16:54

2 votes

1 answer

376 views

Can the citus data coordiator and worker node be on the same machine?

asked Aug 22, 2022 at 22:03

2 votes

0 answers

150 views

How to get the name of a variable instead of its value in plpgsql?

asked Jan 1, 2020 at 17:57

2 votes

2 answers

985 views

Inconsistent behavior of aggregate functions about whether to return NULL on empty input?

asked Jan 31, 2020 at 17:44

2 votes

1 answer

221 views

How to write a wrapper for a heterogeneous VARIADIC function like jsonb_build_object()?

asked Apr 4, 2020 at 19:08

2 votes

1 answer

2k views

How to output string values in single quotes?

asked Oct 13, 2019 at 18:31

2 votes

2 answers

3k views

Do PostgreSQL LATERAL joins require or allow an ON clause?

asked Oct 29, 2021 at 14:57

Stack Exchange Network

60 Questions

How to create a temporary table using VALUES in PostgreSQL

How to get the schema name of a table of type regclass in PostgreSQL?

How to add a PostgreSQL 10 identity column to an existing table?

Are there standard SQL functions with side effects?

Understanding Set Returning Function (SRF) in the SELECT List

self-joins in recursive CTE: `recursive reference must not appear more than once`?

How to use RETURNS TABLE with an existing table in PostgreSQL?

list of PostgreSQL trusted languages?

merging many jsonb objects using aggregate functions in PostgreSQL?

How to change array_agg() to return empty array on empty input in PostgreSQL?

postgresql 10 for Ubuntu 17.10 artful?

disable warning from `drop table if exists`

When is the AS keyword required?

How to quote qualified table name with format() function?

the verbosity of "(SELECT * FROM A)"?

Why is the sum() of zero numbers not zero? [duplicate]

Check if two tables have the same structure (are compatible)

Testing if an element in a PostgreSQL array?

How to get the function name of a regprocedure in PostgreSQL?

how to automatically create the associated schema when I `pg_restore` a table?

How can I specify the last parameters in a function call and let the others default to the DEFAULT in the declaration?

Test if a string is a valid, unquoted identifier?

PostgreSQL DROP DATABASE privilege?

Unable to locate package postgresql-server-dev-15 while installing PostgreSQL 15 using pdpg?

Can the citus data coordiator and worker node be on the same machine?

How to get the name of a variable instead of its value in plpgsql?

Inconsistent behavior of aggregate functions about whether to return NULL on empty input?

How to write a wrapper for a heterogeneous VARIADIC function like jsonb_build_object()?

How to output string values in single quotes?

Do PostgreSQL LATERAL joins require or allow an ON clause?