Skip to content

PostgreSQL: Add columns to a query table with variables

G3rd July 2020 

CNo comments

Generate a new column in your PostgreSQL database query from data in other columns or other tables.

Read the full story

SQL to CSV via Python, with Headers

G7th June 2019 

CNo comments

Nifty Python code that converts a SQL database file into a CSV file and includes column headers.

Read the full story

PostgreSQL: Store a PSQL COUNT query result as a Bash variable

G5th June 2018 

CNo comments

Use this nifty code to isolate the result of a PSQL COUNT query as a variable within a Bash script.

Read the full story

Export a PostgreSQL query to a CSV

G24th November 2017 

C2 comments

Export the contents of a database table to a CSV file using the psql PostgreSQL utility in PuTTY.

Read the full story

Migrate a local LemnaTec database

G8th June 2016 

CNo comments

A step-by-step guide for migrating a local LemnaTec database between network drives.

Read the full story