I want to connect to my newly created database called "test" in psql, I have seen a command like this:
Connection
\c[onnect] {[DBNAME|- USER|- HOST|- PORT|-] | conninfo}
connect to new database (currently "postgres")
What does that mean?
I tried to write:
\c {test|- postgres|- localhost|- 5432|- | conninfo}
but got error:
invalid integer value "5432|-" for connection option "port"
What should I do?
Did you try
\c postgresql://user@localhost/test
Or
\c "host=localhost port=5432 dbname=test connect_timeout=10"