Homepage
Recent Changes
Search:
CategoryPostgreSQL
2019-08-26 PostgreSQL – COALESCE and NULLIF
2019-09-08 PostgreSQL and computing the number of days between two dates
2019-10-28 PostgreSQL, jsonb each and cross joins
2019-12-01 A simple trick with selecting rows created today
2020-02-15 PostgreSQL and null values in jsonb
2020-02-24 Some psql tips
2020-03-02 PostgreSQL on Docker
2020-03-09 Using Org-mode as a PostgreSQL client
2020-03-28 psql as a PostgreSQL teacher
2020-09-27 Pretty printing SQL queries
2020-12-07 Temporary PostgreSQL tables
2020-12-21 Pretty printing json and jsonb columns in PostgreSQL
2021-09-13 A gotcha with PostgreSQL's jsonb type
2021-11-29 Counting the number of columns in PostgreSQL
2022-01-29 Running a script before (and after) starting the psql prompt
2022-02-28 A clever trick with psql copy and multiline select statements
2022-09-12 Shifting dates or timestamps in PostgreSQL
2022-09-26 Knex, PostgreSQL and bytea columns
2023-05-29 A PostgreSQL query to set the serial counter
2024-03-11 More psql tricks
2024-05-04 Pretty printing SQL
2024-06-24 PGmacs - editing PostgreSQL databases from Emacs
2024-08-05 Case-insensitive where in clause
2024-08-26 Deleting table rows based on data from other tables