Skip to content

Instantly share code, notes, and snippets.

@rhysallister
rhysallister / gist:af1ff68b37b7060ea4f9
Created February 14, 2015 22:53
list columns in a table for postgres
SELECT attrelid::regclass, attnum, attname
FROM pg_attribute
WHERE attrelid = 'gn.primaryline'::regclass
AND attnum > 0
AND NOT attisdropped
ORDER BY attnum;