Skip to content

Instantly share code, notes, and snippets.

@bonyiii
Created June 2, 2011 07:04
Show Gist options
  • Select an option

  • Save bonyiii/1004044 to your computer and use it in GitHub Desktop.

Select an option

Save bonyiii/1004044 to your computer and use it in GitHub Desktop.
postgresql show columns from 'table'
SELECT column_name, data_type, udt_name, character_maximum_length FROM information_schema.columns WHERE table_name = 'table';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment