Quickies, by Andrea Olivato

Show tables in #Postgres ( #SQL )

This is a quick replacement for the ‘show tables’ #mysql command when using #postgres. If you’re on a psql shell you can just do ‘\d’ the following scripts refers to the case you need to show tables from an external script.

select tablename from pg_tables where tableowner='yourname';