Skip to content

Instantly share code, notes, and snippets.

@alexhanh

alexhanh/gist:1039342

Created June 22, 2011 01:31
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save alexhanh/1039342 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save alexhanh/1039342 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"players"'::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