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 this week
178 votes
Accepted

Default value for UUID column in Postgres

50 votes
Accepted

Query for all the Postgres configuration parameters‘ current values?

38 votes

What is a valid use case for using TIMESTAMP WITHOUT TIME ZONE?

25 votes

Bad Practice to Store Calculated Data in Database?

23 votes
Accepted

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

20 votes

Refresh materalized view incrementally in PostgreSQL

14 votes
Accepted

One big table vs few smaller

11 votes
Accepted

Time stored using now()::timestamp function stores wrong value

10 votes

PostgreSQL: Generated Columns

10 votes
Accepted

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

10 votes
Accepted

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

10 votes
Accepted

Are PostgreSQL clusters and servers the same thing?

9 votes

How long to learn PostgreSQL?

9 votes
Accepted

Modeling invoices and orders

9 votes
Accepted

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

9 votes
Accepted

Keep H2 in-memory database between connections

8 votes
Accepted

Uninstall Postgres 10 on macOS – EnterpriseDB installer

8 votes

pgAdmin 4 version 3 fails to open a second time

6 votes
Accepted

1000 MB vs. 1024 MB

6 votes
Accepted

Check Constraints on SQL Server Database advisable for number range & year & month?

6 votes
Accepted

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

5 votes
Accepted

Need help in designing a database with a need of adding new columns or tables dynamically

5 votes

Database Design - 'Lists' storage

4 votes
Accepted

Show only duplicate values

4 votes

Modeling a scenario in which each Music Artist is either a Group or a Solo Performer

4 votes
Accepted

How to apply a newly-created Domain to an existing Column?

3 votes
Accepted

For Postgres, how would I define a custom function to generate primary keys?

3 votes
Accepted

Should I create a new table with redundant data for optimization reasons?

3 votes
Accepted

How to do per-tenant backups for multi-tenant databases?

2 votes
Accepted

DB design for my project (addressing people)