chandu-io/Postgres PSQL commands.md

Last active December 6, 2015 07:32

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

Select an option

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

Download ZIP

Raw

Postgres PSQL commands.md

PSQL commands

List all schemas

\dn

List all tables (regular expressions are available)

\dt
\dt public.*
\dt (public|test).*
\dt (public|test).(table1|table2)
\dt (public|test).table*

Create new schema named test

create schema test;

Use schema named test

set schema test;

Get Postgres version

select version();

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