Jochem van Dieten has a good resource on the PostgreSQL for ColdFusion developers. It has things such as queries to list tables, DDL for creating client varaible storage tables, and other tips and tricks. Check it out if you haven't played with PostgreSQL or even if you have.