danilobatistaqueiroz/postgresql_tips.md

Last active November 24, 2017 00:29

Select an option

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

Postgresql Tips

Raw

Postgres Tips

jdbc_url: jdbc:postgresql://localhost:5432/databasename

showing all databases:

SELECT datname FROM pg_database WHERE datistemplate = false;

This lists tables in the current database

SELECT table_schema,table_name FROM information_schema.tables ORDER BY table_schema,table_name;

psql commands

\list or \l: list all databases

\dt: list all tables in the current database

To switch databases: \connect database_name

Links: