postgres - Laur's blog (Page 2)

Oct 2, 2014 database postgres schema size sql

Postgres: Show Schema Sizes in a Database

While loading a large database from files to a Postgres schema, I found very useful to know how much space on disk it actually occupies

Jul 5, 2014 copy_expert csv header load postgres psycopg python

My task is to create a script to load a bunch of files into a DB model. The files are CSV, with quoted strings and

May 15, 2014 copy data insert large performance postgres python

One of the things I did was to write a script to insert records in a PostgreSQL database. The records have with a quite simple

May 13, 2014 call iterate loop postgres procedure sql store

I guess that newbies in PostgreSQL like me have first question when they create a store procedure: How do I call it? The answer is