On 06/04/2015 07:24 AM, Hans Guijt wrote:
Thanks, this is most helpful. I originally found that query somewhere on
the internet and used it as-is.
If I drop the restriction on table name I get a list that also includes
indexes, constraints, etc. Is there a way to restrict the returned set
to tables only?
http://www.postgresql.org/docs/9.4/interactive/catalog-pg-class.html
relkind = 'r'
Hans Guijt
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
