Thursday, March 12, 2009

To list all tables in a PostgreSQL database

select tablename from pg_tables where SUBSTRING(tablename,1,2)<>'pg' order by tablename

No comments: