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@aklaver.com