shawalli/cheatsheet.md

Created August 7, 2018 18:14

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/shawalli/ddc9c8ff35e0e2f733eb53cb617361af.js"></script>
Save shawalli/ddc9c8ff35e0e2f733eb53cb617361af to your computer and use it in GitHub Desktop.

PostGreSQL Query Cheatsheet

Raw

Dump Table Names

SELECT
    *
FROM
    information_schema.tables;

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

SELECT
    table_name,
    column_name,
    data_type 
FROM
    information_schema.columns;

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