Skip to content

Instantly share code, notes, and snippets.

@elcolumbio

elcolumbio/metatable.sql

Created October 6, 2020 11:51
Show Gist options
  • Save elcolumbio/269adb9d6f58df481413ed8f77eb3f0a to your computer and use it in GitHub Desktop.
Save elcolumbio/269adb9d6f58df481413ed8f77eb3f0a to your computer and use it in GitHub Desktop.
Download ZIP
Get Column names and Datatypes from PostgreSQL with SQL
Raw
metatable.sql
select column_name,data_type
from information_schema.columns
where table_name = 'customerorderposition';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment