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
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development