Query a PostgreSQL database via Python
Posted 11th December 2020
No comments
Use this simple template script created in Python to connect to your PostgreSQL database and run a query.
Add a simple search box to a Microsoft Access form
Posted 12th November 2020
6 comments
A step-by-step guide to adding a simple search box to a Microsoft Access form.
PostgreSQL: Add columns to a query table with variables
Posted 3rd July 2020
No comments
Generate a new column in your PostgreSQL database query from data in other columns or other tables.
SQL to CSV via Python, with Headers
Posted 7th June 2019
1 comment
Nifty Python code that converts a SQL database file into a CSV file and includes column headers.
PostgreSQL: Store a PSQL COUNT query result as a Bash variable
Posted 5th June 2018
No comments
Use this nifty code to isolate the result of a PSQL COUNT query as a variable within a Bash script.
Export a PostgreSQL query to a CSV
Posted 24th November 2017
2 comments
Export the contents of a database table to a CSV file using the psql PostgreSQL utility in PuTTY.
Migrate a local LemnaTec database
Posted 8th June 2016
No comments
A step-by-step guide for migrating a local LemnaTec database between network drives.