In PostgreSQL, you can use the \connect
meta-command of the client tool psql:
\connect DBNAME
or in short:
\c DBNAME
Related Contents:
- PostgreSQL “DESCRIBE TABLE”
- How to exit from PostgreSQL command line utility: psql
- psql: FATAL: database “” does not exist
- Run a PostgreSQL .sql file using command line arguments
- How do I specify a password to ‘psql’ non-interactively?
- List tables in a PostgreSQL schema
- Alternate output format for psql
- psql – save results of command to a file
- Using psql how do I list extensions installed in a database?
- Postgresql: Scripting psql execution with password
- How to select a schema in postgres when using psql?
- Library not loaded: /usr/local/opt/readline/lib/libreadline.6.2.dylib
- Find the host name and port using PSQL commands
- Create database from command line
- How to list indexes created for table in postgres
- postgresql port confusion 5433 or 5432?
- PostgreSQL disable more output
- Psql list all tables
- Postgresql not creating db with “createdb” as superuser, yet not outputting errors [duplicate]
- PostgreSQL: Why psql can’t connect to server?
- How can I stop a Postgres script when it encounters an error?
- “psql: could not connect to server: Connection refused” Error when connecting to remote database
- PostgreSQL: Remotely connecting to Postgres instance using psql command
- Alternate output format for psql showing one column per line with column name
- How can I show the content of a trigger with psql?
- Postgres roles best practice implementation
- psql – loop variable of loop over rows must be a record or row variable or list of scalar variables
- Why psql can’t find relation name for existing table?
- Calling functions with exec instead of select
- How can I comment special \ commands in PostgreSQL’s psql commandline tool?
- PostgreSQL: Show all the privileges for a concrete user
- Postgresql – unrecognized configuration parameter
- pg_stat_statements enabled, but the table does not exist
- Where is psql client history kept? (~/.psql_history non-existent!)
- Datatype for a URL in PostgreSQL
- Use psql’s \copy for a multi-line query
- Restore a postgres backup file using the command line?
- Add timestamp column with default NOW() for new rows only
- How to Disconnect from a database and go back to the default database in PostgreSQL?
- How to drop constraint by name in PostgreSQL?
- What does :: do in PostgreSQL? [duplicate]
- Is PostgreSQL suited to one OS? Is it better on Linux than Windows?
- Stop PostgreSQL from starting on Windows?
- PostgreSQL 9.2 – Convert TEXT json string to type json/hstore
- Postgresql: How to find pg_hba.conf file using Mac OS X
- How can I solve Postgresql SCRAM authentication problem?
- currval has not yet been defined this session, how to get multi-session sequences?
- Count months between two timestamp on postgresql?
- “root” execution of the PostgreSQL server is not permitted
- Postgres constraint ensuring one column of many is present?