Forum OpenACS Q&A: Response to How do I get a table listing?

Collapse
2: Response to How do I get a table listing? (response to 1)
Posted by Michael A. Cleverly on 06/09/01 02:17 AM
You can query the pg_class table: select relname from pg_class where relkind = 'r'. (This will include the system tables that psql doesn't show you when you do a dt).

If anyone should ever happen upon this thread searching for the equivalent answer for Solid, the query would be: select table_name from sys_tables.