Switching between different servers in postgresql sql shell command

Question

Since I am new to postgresql shell command lines, I am very much confused on switch between servers, databases. First, I have logged in using default values in shellSql window. It is opening second server in my pgadmin server lists(in order). But my question here is how to switch between different servers through shell commands? Example: If I have 3 servers (postgresql9, postgresql11 and remote servers).

and use \conninfo to check where you are currently connected to, see: \? for more options — Luuk
– Luuk, Commented Feb 23, 2020 at 10:15

Ajay Tom George · Accepted Answer · 2020-02-23 10:30:12Z

2

This is directly given in documentation PSQL-META-COMMANDS

Examples:

=> \c mydb myuser host.dom 6432
=> \c service=foo
=> \c "host=localhost port=5432 dbname=mydb connect_timeout=10 sslmode=disable"
=> \c postgresql://tom@localhost/mydb?application_name=myapp

answered Feb 23, 2020 at 10:30

Ajay Tom George

2,3672 gold badges19 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

Switching between different servers in postgresql sql shell command

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related