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.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
