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