Skip to main content
Basil Bourque's user avatar
Basil Bourque's user avatar
Basil Bourque's user avatar
Basil Bourque
  • Member for 11 years, 4 months
  • Last seen more than a week ago
135 votes
3 answers
243k views

Default value for UUID column in Postgres

40 votes
3 answers
49k views

pgAdmin 4 version 3 fails to open a second time

31 votes
2 answers
63k views

Automatic aging-out (deletion) of old records in Postgres

26 votes
1 answer
90k views

Query for all the Postgres configuration parameters‘ current values?

25 votes
2 answers
25k views

What is the data type of the ‘ctid’ system column in Postgres?

19 votes
2 answers
7k views

What is a “transition table" in Postgres?

18 votes
4 answers
11k views

Does Postgres offer a feature like “NEWSEQUENTIALID” in MS SQL Server to make UUID as primary key more efficient

16 votes
1 answer
3k views

Why does time zone have such a crazy offset-from-UTC on year 0001 in Postgres?

13 votes
2 answers
25k views

When the primary key is also the foreign key, in Postgres

10 votes
1 answer
13k views

Exactly what error is returned by PostgreSQL `FOR UPDATE NOWAIT` when a selected row cannot be locked immediately?

10 votes
1 answer
43k views

How to edit `postgresql.conf` with pgAdmin 3?

8 votes
2 answers
6k views

Track my own custom metadata on Postgres tables and columns

8 votes
1 answer
4k views

Specify ICU collations as `ENCODING`, `LC_COLLATE`, and `LC_CTYPE` in Postgres 10

8 votes
2 answers
11k views

Uninstall Postgres 10 on macOS – EnterpriseDB installer

8 votes
1 answer
2k views

How to tell if Postgres was built with the option to include LLVM technology for JIT?

7 votes
2 answers
8k views

Returning multiple result sets from server-side procedures in Postgres 11

7 votes
1 answer
9k views

How to get information about the sequence behind the new Identity Column in Postgres 10? (GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY)

7 votes
1 answer
2k views

Does Microsoft SQL Server offer an Advisory Locks feature like Postgres?

7 votes
2 answers
20k views

See entire string from a lengthy text field in pgAdmin?

6 votes
1 answer
11k views

Keep H2 in-memory database between connections

5 votes
1 answer
4k views

Limits of applock in MS SQL Server

5 votes
1 answer
2k views

Prevent DROP COLUMN in PostgreSQL

4 votes
2 answers
5k views

Table design for “Users & Groups” plus “Groups within Groups”

4 votes
1 answer
23k views

How to edit `postgresql.conf` with pgAdmin 4?

4 votes
2 answers
21k views

Switch user to 'postgres' user on macOS results in "su: Sorry" error

3 votes
1 answer
2k views

Was my Postgres cluster built with the ICU libraries available for Postgres 10 and later?

3 votes
1 answer
4k views

`uuid_generate_v1mc` in Postgres “uuid-ossp” module: What is random multicast MAC address?

3 votes
1 answer
31k views

Row with latest timestamp

3 votes
2 answers
269 views

Detect if `pg_crypto` in Postgres was built with strong random feature enabled

3 votes
0 answers
76 views

On the INSERT statement in H2, what does `DIRECT` mean?