Here is the best way (I have found) to list all tables in a postgres database
select relname from pg_class pc left join pg_namespace ns ON ns.oid=pc.relnamespace where pc.relkind='r' and nspname='public' order by relname asc;
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment