Showing posts with label database. Show all posts
Showing posts with label database. Show all posts

Get Tables in PostgreSQL (Postgres)

This is how you get a list of tables in Postgres.

SELECT tablename FROM pg_tables
WHERE tablename NOT LIKE ‘pg\\_%’
AND tablename NOT LIKE ’sql\\_%’,
order by tablename;

Posted at on 12/9/08 by | 0 comments | Filed under: , ,