Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save juelvaldivia/14ce1fe5b2612c6a7a60292453847478 to your computer and use it in GitHub Desktop.
Save juelvaldivia/14ce1fe5b2612c6a7a60292453847478 to your computer and use it in GitHub Desktop.
SELECT
t1.COLUMN_NAME AS columna_nombre,
t1.COLUMN_DEFAULT AS columna_defecto,
t1.IS_NULLABLE AS columna_nulo,
t1.DATA_TYPE AS columna_tipo_dato,
COALESCE(t1.NUMERIC_PRECISION,
t1.CHARACTER_MAXIMUM_LENGTH) AS columna_longitud,
PG_CATALOG.COL_DESCRIPTION(t2.OID,
t1.DTD_IDENTIFIER::int) AS columna_descripcion,
t1.DOMAIN_NAME AS columna_dominio
FROM
INFORMATION_SCHEMA.COLUMNS t1
INNER JOIN PG_CLASS t2 ON (t2.RELNAME = t1.TABLE_NAME)
WHERE
t1.TABLE_SCHEMA = '[NOMBRE_ESQUEMA]' AND
t1.TABLE_NAME = '[NOMBRE_TABLA]'
ORDER BY
t1.ORDINAL_POSITION;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment