In PostgreSQL, you can use the \connect
meta-command of the client tool psql:
\connect DBNAME
or in short:
\c DBNAME
More Related Contents:
- PostgreSQL “DESCRIBE TABLE”
- How to exit from PostgreSQL command line utility: psql
- In psql, why do some commands have no effect?
- How do I specify a password to ‘psql’ non-interactively?
- Run batch file with psql command without password
- Run a PostgreSQL .sql file using command line arguments
- Postgresql: Scripting psql execution with password
- “psql: could not connect to server: Connection refused” Error when connecting to remote database
- psql: FATAL: database “” does not exist
- PostgreSQL: Why psql can’t connect to server?
- Use variable set by psql meta-command inside of DO block
- Alternate output format for psql showing one column per line with column name
- Library not loaded: /usr/local/opt/readline/lib/libreadline.6.2.dylib
- PostgreSQL disable more output
- Importing .csv with timestamp column (dd.mm.yyyy hh.mm.ss) using psql \copy
- Insert, on duplicate update in PostgreSQL?
- How does the search_path influence identifier resolution and the “current schema”
- How do you find the row count for all your tables in Postgres
- Postgresql: Conditionally unique constraint
- How do you use variables in a simple PostgreSQL script?
- ClassNotFoundException with PostgreSQL and JDBC
- How to get function parameter lists (so I can drop a function)
- How to convert a postgres database to sqlite
- How can I change a PostgreSQL user password?
- I forgot the password I entered during PostgreSQL installation
- Function to loop through and select data from multiple tables
- SQL query column does not exist error
- SQL Sub queries in check constraint
- Postgresql enforce unique two-way combination of columns
- Orbeon Forms Postgres DB connection