Skip to content

Instantly share code, notes, and snippets.

@jbdesbas

jbdesbas/col_description.sql

Created March 1, 2023 10:50
Show Gist options
  • Save jbdesbas/a376a04a867779f1c411d6d3aa779ee8 to your computer and use it in GitHub Desktop.
Save jbdesbas/a376a04a867779f1c411d6d3aa779ee8 to your computer and use it in GitHub Desktop.
Download ZIP
Get columns description
Raw
col_description.sql
select table_name, column_name, col_description((table_schema||'.'||table_name)::text::regclass, ordinal_position)
from information_schema.COLUMNS
where table_schema = 'sinoe' and table_name LIKE 'ind_reg%';
-- https://stackoverflow.com/a/44493548/10995624
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment