Skip to content

Instantly share code, notes, and snippets.

@avkosme
Created July 4, 2023 11:59
Show Gist options
  • Save avkosme/3242a5bd2a00d68e0e636962fad423a8 to your computer and use it in GitHub Desktop.
Save avkosme/3242a5bd2a00d68e0e636962fad423a8 to your computer and use it in GitHub Desktop.
Describe table PG
SELECT
table_name,
column_name,
data_type
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