Skip to content

Instantly share code, notes, and snippets.

@RaulMedeiros

RaulMedeiros/get list: table column names PG

Created July 30, 2020 15:06
Show Gist options
  • Save RaulMedeiros/524d8313176e17a5c8cbb2fc1d3471b3 to your computer and use it in GitHub Desktop.
Save RaulMedeiros/524d8313176e17a5c8cbb2fc1d3471b3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
get list: table column names PG
SELECT column_name
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = 'table_name';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment