how to access specific database in postgresql

Question

I have created database in postgresql and want to connect database use command like use databaseName but its not working.What is the command to access specific date base in postgresql.

in my sql if want connect database we will use command like use databaseName not working in postgresql.

user11044402 · Accepted Answer · 2019-08-28 13:37:38Z

0

See the documentation for psql:

-d dbname

--dbname=dbname

Specifies the name of the database to connect to.

If you are already connected:

\c or \connect [ -reuse-previous=on|off ] [ dbname [ username ] [ host ] [ port ] | conninfo ]

answered Aug 28, 2019 at 13:37

user11044402

Sign up to request clarification or add additional context in comments.

Comments

cn0047 · Accepted Answer · 2019-08-28 13:43:14Z

0

In shell:

psql -d postgres://dbuser:dbpwd@dbhost/databaseName

In postgresql repl:

\c databaseName

answered Aug 28, 2019 at 13:43

cn0047

17.2k7 gold badges61 silver badges75 bronze badges

Collectives™ on Stack Overflow

how to access specific database in postgresql

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related