Jasen's user avatar
Jasen's user avatar
Jasen's user avatar
Jasen
  • Member for 8 years, 4 months
  • Last seen more than a week ago
30 votes
Accepted

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

11 votes
Accepted

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

10 votes

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

6 votes
Accepted

json_object_agg errors on null in field name

5 votes
Accepted

Name of not null constraint is missing in error message

5 votes
Accepted

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

5 votes

Advantages to column constraints over table constraints

5 votes

How to limit rows in PostgreSQL update statement

4 votes

Dangers in dropping all tables in a schema with CASCADE

4 votes

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

4 votes

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

4 votes
Accepted

Select only the last record for multiple values

3 votes
Accepted

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

3 votes

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

3 votes
Accepted

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

3 votes

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

3 votes

How to auto-increment a serial column ON UPDATE?

3 votes
Accepted

Is there any string compaction option for PostgreSQL?

3 votes

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

3 votes

Distributing a single table across multiple disks of different performance?

3 votes
Accepted

Possible to drop table ignoring dependencies?

3 votes

Presto SQL: TO_UNIXTIME

3 votes
Accepted

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

3 votes
Accepted

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

3 votes

Performance of large transactions and concurrency?

2 votes

PostgreSQL insert record by trigger

2 votes
Accepted

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

2 votes

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

2 votes

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

2 votes
Accepted

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

1
2 3 4 5