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

Posted by Michael A. Cleverly on
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.