Check size of PostgreSQL databases
A minimal example on how to check size of all databases in a PostgreSQL server.
postgresql
Run PostgreSQL function from Windows commandline
A minimal example on how to run a PostgreSQL function from Windows commandline using psql.
Add created and edited user and date in PostgreSQL
A minimal example on how to add attributes in PostgreSQL table with autofilling created user and date and last edited user and date.
Archive deleted PostgreSQL rows by copying them to another table
A minimal example for PostgreSQL on how to copy database rows into another table when they are deleted in the original table.
Automate PostgreSQL database backup
A minimal example on how to use pg_dump in a .bat script to automate PostgreSQL database backups on Windows operating system.
Cast point geometry from 2D to 3D
A minimal example on how to use SQL in PostGIS to cast table’s point geometry between Z- and/or M-enabled points.
Restrict PostgreSQL row edits by username
A minimal example on how to limit row edits on a PostgreSQL table to a user matching a username value in one of the row’s columns.