PostGreSQL Query Cheatsheet

cheatsheet.md

Dump Table Names

All

SELECT
    *
FROM
    information_schema.tables;

Non-PostGreSQL

SELECT
    *
FROM
    information_schema.tables
WHERE
    table_schema != 'pg_catalog';

Dump Column Info From All Tables

SELECT
    table_name,
    column_name,
    data_type 
FROM
    information_schema.columns;

Dump Function

SELECT
    pg_get_functiondef(
        '<FUNCTION_NAME>'::regproc
    );

Important Tables

• information_schema.tables
• information_schema.columns
• information_schema.triggers