Working with postgresql via command line
Sometimes, you can’t use your favorite Database tool, the command line is all you got2
- When connect to postgres database, we have to specifiy the database name in the connection command. For example
psql -U {username} -h {host} -D {database_name}