Category Archives: Database

PostgreSQL information_schema

Posted on 08/26/2010 by Syed Ullah

PostgreSQL has a special schema named information_schema where it stores meta data about database objects (somewhat like Oracle’s DBA_* tables). If you want to iterate over all the tables in some schema and do some special processing on each of … Continue reading →

Posted in Database | Tagged , , , , | Leave a comment

Using COPY command in PostgreSQL

Posted on 08/19/2010 by Syed Ullah

Postgres has a very useful ‘COPY’ command that can be used to transfer data between text files and database tables. This is somewhat similar to Oracle’s SQLLDR utility. I will discuss some of the basic commands to get data from … Continue reading →

Posted in Database | Tagged , , , , , , , | 2 Comments