Working with postgresql via command line

Sometimes, you can’t use your favorite Database tool, the command line is all you got2

  1. 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}



For those who are interested in automating the stuffs, CI/CD pipeline, automation test..

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Donald Le

A passionate automation engineer who strongly believes in “A man can do anything he wants if he puts in the work”.