davidbarkhuizen/psql.md

Last active November 1, 2022 11:37

Select an option

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

postgresql

Raw

switch to posgres user

sudo -i -u postgres

createdb xxx

\c xxx

select * from pg_catalog.pg_tables;

select column_name, data_type, character_maximum_length from INFORMATION_SCHEMA.COLUMNS where table_name = '';