User Jasen

30 votes

Accepted

PostgreSQL two different ways to generate a UUID: gen_random_uuid vs uuid_generate_v4?

answered May 5, 2018 at 9:21

11 votes

Accepted

How to prevent asking for password when creating new database in PostgreSQL 10?

answered Jun 8, 2018 at 23:25

10 votes

Is there a way to insert multiple rows into a table with default values for all columns?

answered Sep 21, 2022 at 12:00

6 votes

Accepted

json_object_agg errors on null in field name

answered Jun 27, 2019 at 21:51

5 votes

Accepted

Name of not null constraint is missing in error message

answered Jun 12, 2018 at 7:15

5 votes

Accepted

Indexing the condition lower(f) LIKE '%foo%'

answered May 2, 2018 at 12:06

5 votes

Advantages to column constraints over table constraints

answered Jun 16, 2018 at 0:38

5 votes

How to limit rows in PostgreSQL update statement

answered Jul 28, 2018 at 1:51

4 votes

Dangers in dropping all tables in a schema with CASCADE

answered Jun 16, 2018 at 0:43

4 votes

What is purpose of `ALLOW_CONNECTIONS` being set so no one can connect to the new Postgres database?

answered Oct 28, 2018 at 5:56

4 votes

Is there a way to connect to postgres when have error "sorry, too many clients already "?

answered May 26, 2018 at 9:55

4 votes

Accepted

Select only the last record for multiple values

answered Dec 19, 2018 at 8:39

3 votes

Accepted

In BEFORE UPDATE TRIGGER, how do I prevent changing nothing but timestamp?

answered Mar 5, 2019 at 7:26

3 votes

How to prove the lack of implicit order in a database?

answered Jan 28, 2019 at 7:20

3 votes

Accepted

Postgres 12: declare a function as constant or immutable ignoring parameters?

answered Jan 30, 2020 at 6:37

3 votes

How to estimate the size of a PostgreSQL DB to be dumped through pg_dump

answered Jun 19, 2021 at 7:50

3 votes

How to auto-increment a serial column ON UPDATE?

answered Jun 25, 2021 at 4:16

3 votes

Accepted

Is there any string compaction option for PostgreSQL?

answered May 27, 2018 at 5:23

3 votes

Does a query with a primary key and foreign keys run faster than a query with just primary keys?

answered May 26, 2018 at 8:55

3 votes

Distributing a single table across multiple disks of different performance?

answered Apr 16, 2018 at 4:54

3 votes

Accepted

Possible to drop table ignoring dependencies?

answered May 6, 2018 at 6:22

3 votes

Presto SQL: TO_UNIXTIME

answered Aug 26, 2018 at 10:30

3 votes

Accepted

Create 2D truth table from "cross product" of two tables via PostgreSQL view or function

answered Oct 13, 2018 at 20:05

3 votes

Accepted

Is there a way to obtain 'NaN' using only numbers?

answered Nov 3, 2018 at 19:49

3 votes

Performance of large transactions and concurrency?

answered Nov 11, 2018 at 5:39

2 votes

PostgreSQL insert record by trigger

answered Aug 13, 2018 at 10:31

2 votes

Accepted

How to use "WHERE" and also "WHERE NOT EXISTS" in the same query and table?

answered Jul 13, 2018 at 6:14

2 votes

In Postgres 10, how do the choice of SERIAL or UUID type as primary key affect replication, if at all?

answered Jun 13, 2018 at 8:57

2 votes

What are current values in PG admin configuration editor for postgresql.conf

answered Jul 26, 2018 at 9:11

2 votes

Accepted

Will my query continue to execute after I shut off my computer

answered Jul 28, 2018 at 21:12

Stack Exchange Network

140 Answers

PostgreSQL two different ways to generate a UUID: gen_random_uuid vs uuid_generate_v4?

How to prevent asking for password when creating new database in PostgreSQL 10?

Is there a way to insert multiple rows into a table with default values for all columns?

json_object_agg errors on null in field name

Name of not null constraint is missing in error message

Indexing the condition lower(f) LIKE '%foo%'

Advantages to column constraints over table constraints

How to limit rows in PostgreSQL update statement

Dangers in dropping all tables in a schema with CASCADE

What is purpose of `ALLOW_CONNECTIONS` being set so no one can connect to the new Postgres database?

Is there a way to connect to postgres when have error "sorry, too many clients already "?

Select only the last record for multiple values

In BEFORE UPDATE TRIGGER, how do I prevent changing nothing but timestamp?

How to prove the lack of implicit order in a database?

Postgres 12: declare a function as constant or immutable ignoring parameters?

How to estimate the size of a PostgreSQL DB to be dumped through pg_dump

How to auto-increment a serial column ON UPDATE?

Is there any string compaction option for PostgreSQL?

Does a query with a primary key and foreign keys run faster than a query with just primary keys?

Distributing a single table across multiple disks of different performance?

Possible to drop table ignoring dependencies?

Presto SQL: TO_UNIXTIME

Create 2D truth table from "cross product" of two tables via PostgreSQL view or function

Is there a way to obtain 'NaN' using only numbers?

Performance of large transactions and concurrency?

PostgreSQL insert record by trigger

How to use "WHERE" and also "WHERE NOT EXISTS" in the same query and table?

In Postgres 10, how do the choice of SERIAL or UUID type as primary key affect replication, if at all?

What are current values in PG admin configuration editor for postgresql.conf

Will my query continue to execute after I shut off my computer