Tutorial: UNIQUE constraint on NULL values in PostgreSQL 21 March 2017 Posted in: Database About: Distinguishing between NULL values is impossible, as per SQL standard. These are my favorite workarounds for one and multiple columns.
Tutorial: sizes of tables and databases in PostgreSQL 19 March 2017 Posted in: Database About: How big are PostgreSQL tables in terms of rows and disk space? Here are some queries to get their sizes.
Tutorial: read-only PostgreSQL user 21 February 2017 Posted in: Database About: PostgreSQL is installed, the tables are planned or already created. Now how do I create a read-only user that can access one/some/all tables in a schema but not UPDATE, INSERT or DELETE anything?