Wednesday, August 3, 2011


When using the psql command line interface for PostgreSQL here is the command to get a list of all the tables in the database for a particular schema.

SELECT tablename FROM pg_tables WHERE schemaname = 'someschema';

Just replace someschema with your actual schema name and fire it off.  Voila a list of all the tables. #commandline4eva

No comments:

Post a Comment