Simple Postgres Commands I always forget
Here are some simple Postgres commands that I almost always forget
I am a simple man with simple needs. Here are the Postgres commands I use most often that I always forget so have written them here.
- Connecting in locally –
psql -d db_name
- Listing databases –
\l
- Listing tables –
\d
- Listing schemas -
\dn
- Connecting to a different table –
\c
- Getting help with these
\
commands –\?
- Quitting –
\q
I fully expect I will be the only reader of this post!