Wednesday, August 3, 2011

PostgreSQL

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