efrecon/gist:21ebe0214a4d34cbc176d39727da790c

Created October 3, 2018 14:17

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

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

Download ZIP

List all tables in a given postgres db

Raw

gistfile1.txt

echo "SELECT table_schema || '.' || table_name FROM information_schema.tables WHERE table_type = 'BASE TABLE' AND table_schema NOT IN ('pg_catalog', 'information_schema');" | psql -U postgres -d dbname -q -t

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment