Basil Bourque
  • Member for 8 years, 11 months
  • Last seen this week
2 answers
102 votes
159k views
32 bookmarks
Default value for UUID column in Postgres
3 answers
38 votes
43k views
3 bookmarks
pgAdmin 4 version 3 fails to open a second time
1 answers
20 votes
34k views
2 bookmarks
Automatic aging-out (deletion) of old records in Postgres
2 answers
16 votes
13k views
1 bookmarks
What is the data type of the ‘ctid’ system column in Postgres?
2 answers
16 votes
4k views
2 bookmarks
What is a “transition table" in Postgres?
1 answers
16 votes
2k views
Why does time zone have such a crazy offset-from-UTC on year 0001 in Postgres?
3 answers
14 votes
5k views
4 bookmarks
Does Postgres offer a feature like “NEWSEQUENTIALID” in MS SQL Server to make UUID as primary key more efficient
1 answers
10 votes
35k views
1 bookmarks
How to edit `postgresql.conf` with pgAdmin 3?
2 answers
9 votes
8k views
1 bookmarks
When the primary key is also the foreign key, in Postgres
1 answers
9 votes
25k views
5 bookmarks
Query for all the Postgres configuration parameters‘ current values?
1 answers
9 votes
8k views
Exactly what error is returned by PostgreSQL `FOR UPDATE NOWAIT` when a selected row cannot be locked immediately?
2 answers
7 votes
3k views
Track my own custom metadata on Postgres tables and columns
2 answers
6 votes
16k views
1 bookmarks
See entire string from a lengthy text field in pgAdmin?
2 answers
6 votes
5k views
1 bookmarks
Returning multiple result sets from server-side procedures in Postgres 11
2 answers
6 votes
10k views
3 bookmarks
Uninstall Postgres 10 on macOS – EnterpriseDB installer
1 answers
6 votes
3k views
1 bookmarks
Specify ICU collations as `ENCODING`, `LC_COLLATE`, and `LC_CTYPE` in Postgres 10
1 answers
5 votes
6k views
How to get information about the sequence behind the new Identity Column in Postgres 10? (GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY)
1 answers
5 votes
1k views
2 bookmarks
Prevent DROP COLUMN in PostgreSQL
1 answers
5 votes
3k views
2 bookmarks
Limits of applock in MS SQL Server
1 answers
5 votes
836 views
2 bookmarks
Does Microsoft SQL Server offer an Advisory Locks feature like Postgres?
1 answers
4 votes
544 views
2 bookmarks
How to tell if Postgres was built with the option to include LLVM technology for JIT?
2 answers
3 votes
3k views
Table design for “Users & Groups” plus “Groups within Groups”
1 answers
3 votes
2k views
`uuid_generate_v1mc` in Postgres “uuid-ossp” module: What is random multicast MAC address?
1 answers
3 votes
7k views
1 bookmarks
Keep H2 in-memory database between connections
0 answers
3 votes
40 views
On the INSERT statement in H2, what does `DIRECT` mean?
2 answers
3 votes
13k views
1 bookmarks
Switch user to 'postgres' user on macOS results in "su: Sorry" error
1 answers
3 votes
13k views
How to edit `postgresql.conf` with pgAdmin 4?
1 answers
3 votes
818 views
Was my Postgres cluster built with the ICU libraries available for Postgres 10 and later?
2 answers
3 votes
166 views
Detect if `pg_crypto` in Postgres was built with strong random feature enabled
1 answers
2 votes
207 views
Does the SQL-1992 standard restrict naming identifiers to 18 characters?