Working with postgresql via command line

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

Photo by Pawel Czerwinski on Unsplash
  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..

Recommended from Medium

Configuring different AWS profiles for Serverless deployment

Final Entry

Deploying a Web App, an API, and a Website under the same domain

Archiving Bitbucket Server repositories to S3 or GCS

7 System Building Tips

Do you Git it?

A blueprint for Scandiweb Support

The Definition of Application Modernization

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

Donald Le

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

More from Medium

Five useful tools to improve your R&D efficiency

How to basic working with index and documents and use the search functionality

Printing Response time on apache and nginx logs

Azure web app on a shoestring budget