On 02/18/2016 01:15 PM, Killian Driscoll wrote: > On 18 February 2016 at 22:01, Joe Conway wrote: > WHERE NOT n.nspname LIKE 'pg\_%' > AND NOT n.nspname = 'information_schema' > AND a.attnum > 0 > AND c.relkind = 'r' > UNION ALL
> This works - thank you. I see in column "a.attname as column_name", > there are a few rows with data like '......pg.dropped.3.....': what are > these?
Those are columns that have been dropped after the table was created. You could filter those out by adding
AND NOT a.attisdropped
into the WHERE clause before the UNION ALL
Joe
Perfect, thank you,
-- Crunchy Data - http://crunchydata.com PostgreSQL Support for Secure Enterprises Consulting, Training, & Open Source Development
--
Killian DriscoIl IRC Postdoctoral Fellow UCD School of Archaeology University College Dublin
