Skip to content

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 

C1 comment

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