Skip to content

Instantly share code, notes, and snippets.

@smathy

smathy/quuery.sql

Created May 22, 2015 22:35
Show Gist options
  • Save smathy/8027cbc40b5d25945a09 to your computer and use it in GitHub Desktop.
Save smathy/8027cbc40b5d25945a09 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
quuery.sql
SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = 'researchers'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment