Hello!

Today we are going to talk about what is equivalent of use database command in PostgreSQL.

Use database_name command mostly, refers to changing database connection in most of the database engines. For instance you are working on HR database and need to change your connection to MRP database to update some settings on MRP database. In that situationg you can run a use database_name statement. PostgreSQL provides a different option for use database command in PostgreSQL

TL;DR \c database_name

Use Database_name Command

Switching beetwen databases usually requires a disconnect and connect. Some database engines provides this feature with use command. In PostgreSQL’s psql, this feature is provided with \c command.

Connect Command in PostgreSQL

Connect command is (\c and \connect commands are aliases) command used to connect databases.

In this page, you can find documentation of \c and \connect commands.