Postgres

Resources

• Lesser Known PostgreSQL Features
  • find current value of sequence
  • copy out data with COPY (...) TO STDOUT WITH CSV HEADER \g file.csv;
  • comment on any database object with COMMENT ON ... IS 'comment';
• Postgres Auditing in 150 lines of SQL
• The Internals of PostgreSQL
• Nine ways to shoot yourself in the foot with PostgreSQL