Use XPath in PL/PGSQL for Batch Processing
A while ago I had to process XML loaded in a PostgreSQL database. The task was to extract references from a publication structure. Fortunately, PostgreSQL
postgres
Migrate PostgreSQL Between Two Machines
TL;DR: Once you prepare the connection, pg_dump is your friend.
Recently, we had to migrate a large-ish DB (1.5 TB) from a
Add XML to PostgreSQL from Python
One of the projects I worked on was to import a large number of XML files in a PostgreSQL database (as XML files). I chose
Add Primary Key Column to PostgreSQL Table
The other day I got a question:
How to add a numeric PK column to an already existent table?
A quick look on the net
Fuzzy String Matching in PostgreSQL
A database I am working on has a lot of records (40M+) and the guys mining it are currently using python to process it. This