Showing posts with label sql postgresql psql. Show all posts
Showing posts with label sql postgresql psql. Show all posts

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