How to switch databases in psql

Question

In MySQL  I used use database name   What s the psql equivalent

User · Answer

At the PSQL prompt  you can do     connect  or  c  dbname

User · Answer

You can also connect to a database with a different ROLE as follows     connect DBNAME ROLENAME    or    c DBNAME ROLENAME

User · Answer

Use below statement to switch to different databases residing inside your postgreSQL RDMS   c databaseName

User · Answer

Connect to database     Method 1   enter to db   sudo -u postgres psql    Connect to db    c dbname    Method 2   directly connect to db   sudo -u postgres psql -d my database name

User · Answer

You can connect using   c dbname  If you would like to see all possible commands for POSTGRESQL or SQL follow this steps     rails dbconsole  You will redericted to your current ENV database      For POSTGRESQL commands    or    h  For SQL commands  Press Q to Exit

User · Answer

Listing and Switching Databases in PostgreSQL When you need to change between databases  you   ll use the  connect command  or  c followed by the database name as shown below  postgres    connect database name postgres    c database name  Check the database you are currently connected to  SELECT current database     PostgreSQL List Databases postgres    l  postgres    list

User · Answer

You can select the database when connecting with psql  This is handy when using it from a script   sudo -u postgres psql -c  CREATE SCHEMA test AUTHORIZATION test   test

User · Answer

Using psql s meta-command   c or  connect   dbname   username     host     port       conninfo  see documentation    Example   c MyDatabase  Note that the  c and  connect meta-commands are case-sensitive

User · Answer

l for databases  c DatabaseName to switch to db  df for procedures stored in particular database

User · Answer

You can connect to a database with  c  lt database gt  or  connect  lt database gt

User · Answer

Though not explicitly stated in the question  the purpose is to connect to a specific schema database   Another option is to directly connect to the schema  Example   sudo -u postgres psql -d my database name  Source from man psql   -d dbname --dbname dbname    Specifies the name of the database to connect to  This is equivalent to specifying dbname as the first non-option argument on the command line      If this parameter contains an   sign or starts with a valid URI prefix  postgresql    or postgres      it is treated as a conninfo string  See Section 31 1 1     Connection Strings     in the    documentation for more information

User · Answer

If you want to switch to a specific database on startup  try   Applications Postgres app Contents Versions 9 5 bin psql vigneshdb   By default  Postgres runs on the port 5432  If it runs on another  make sure to pass the port in the command line    Applications Postgres app Contents Versions 9 5 bin psql -p2345 vigneshdb   By a simple alias  we can make it handy   Create an alias in your  bashrc or  bash profile  function psql         db vigneshdb     if     1          then             db  1     fi      Applications Postgres app Contents Versions 9 5 bin psql -p5432  1     Run psql in command line  it will switch to default database  psql anotherdb  it will switch to the db with the name in argument  on startup

User · Answer

In PostgreSQL  you can use the  connect meta-command of the client tool psql    connect DBNAME   or in short    c DBNAME

[postgresql] How to switch databases in psql?

Examples related to postgresql

Examples related to psql