Ashish Patel: TIL

Atom feed

Recently added: Dotnet Common commands, NestJS Common commands, Flask Common commands, Django Common commands, PostgreSQL Common commands

PostgreSQL Common commands

# login
psql -d database -U  user -W
psql -h host -d database -U user -W
psql -U user -h host "dbname=db sslmode=require"

# list of dbs
\l

# switch db
\c dbname username

# list of tables
\dt

Created 2021-03-02T13:26:50+05:30, updated 2021-10-20T01:24:33+01:00 · History · Edit