How to switch from database in postgres with psql?

Question

I try to switch with powershell from databases with postgres (14.1)

So I do this:

postgres-# \l

And then I see all the databases. But for example how can I now switch to the test database?

  Name    |  Owner   | Encoding |         Collate          |          Ctype           |   Access privileges
-----------+----------+----------+--------------------------+--------------------------+-----------------------
 postgres  | postgres | UTF8     | English_Netherlands.1252 | English_Netherlands.1252 |
 template0 | postgres | UTF8     | English_Netherlands.1252 | English_Netherlands.1252 | =c/postgres          +
           |          |          |                          |                          | postgres=CTc/postgres
 template1 | postgres | UTF8     | English_Netherlands.1252 | English_Netherlands.1252 | =c/postgres          +
           |          |          |                          |                          | postgres=CTc/postgres
 test      | postgres | UTF8     | English_Netherlands.1252 | English_Netherlands.1252 |
(4 rows)

I try it like this:

postgres-# -d --test

But that doesn't work.

score 2 · Accepted Answer · 2021-12-10 14:49:28Z

2

Use \connect (or just \c)

Quote from the manual

\c or \connect
Establishes a new connection to a PostgreSQL server. The connection parameters to use can be specified either using a positional syntax (one or more of database name, user, host, and port), or using a conninfo connection string as detailed in Section 34.1.1. If no arguments are given, a new connection is made using the same parameters as before.

The -d parameter can only be used when starting psql:

PS c:\> psql -d test

edited Dec 10, 2021 at 14:49

answered Dec 10, 2021 at 14:45

user330315

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

1 Comment

mightycode Newton Over a year ago

ahhh, oke. Thank you!! oke

Collectives™ on Stack Overflow

How to switch from database in postgres with psql?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related