Month: December 2013
-
PostgreSQL trivia
Sometimes it is necessary to use the psql command line tool to quickly explore odds in database. Often you also need to use some commands to view structure of your database or tables. In PostgreSQL (and also in other database systems) you can do that by querying system tables like pg_tables , pg_class , pg_attribute and so on.