“use database_name” command in PostgreSQL

When you get a connection to PostgreSQL it is always to a particular database. To access a different database, you must get a new connection.

Using \c in psql closes the old connection and acquires a new one, using the specified database and/or credentials. You get a whole new back-end process and everything.

Related Posts:

  1. PostgreSQL: Show tables in PostgreSQL
  2. Psql could not connect to server: No such file or directory, 5432 error?
  3. Getting error: Peer authentication failed for user “postgres”, when trying to get pgsql working with rails
  4. What is the format for the PostgreSQL connection string / URL?
  5. PSQLException: current transaction is aborted, commands ignored until end of transaction block
  6. psql: FATAL: Ident authentication failed for user “postgres”
  7. fe_sendauth: no password supplied
  8. How can I drop all the tables in a PostgreSQL database?
  9. How to restart PostgreSQL in Ubuntu 18.04
  10. FATAL: password authentication failed for user “postgres” (postgresql 11 with pgAdmin 4)
  11. Postgresql: Scripting psql execution with password
  12. postgresql duplicate key violates unique constraint
  13. “psql: could not connect to server: Connection refused” Error when connecting to remote database
  14. How to change PostgreSQL user password?
  15. No function matches the given name and argument types
  16. PostgreSQL error: Fatal: role “username” does not exist
  17. How to change PostgreSQL user password?
  18. How to exit from PostgreSQL command line utility: psql
  19. psql: FATAL: database “” does not exist
  20. eroku “psql: FATAL: remaining connection slots are reserved for non-replication superuser connections”
  21. Permission denied for relation
  22. postgres does not know where to find server configuration
  23. input file appears to be a text format dump. Please use psql
  24. PG COPY error: invalid input syntax for integer
  25. Postgres: INSERT if does not exist already
  26. What’s the default superuser username/password for postgres after a new install?
  27. How to see active connections and “current activity” in PostgreSQL 8.4
  28. pg_dump and pg_restore: input file does not appear to be a valid archive
  29. What is this JavaScript “require”?
  30. What is this JavaScript “require”?
  31. PostgreSQL “DESCRIBE TABLE”
  32. How to UPSERT (MERGE, INSERT … ON DUPLICATE UPDATE) in PostgreSQL?
  33. How to restart Postgresql
  34. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  35. What is the default password for Postgres
  36. Postgresql 9.2 pg_dump version mismatch
  37. missing FROM-clause entry for table
  38. PostgreSQL: Remotely connecting to Postgres instance using psql command
  39. Simple Random Samples from a Sql database
  40. Insert text with single quotes in PostgreSQL
  41. ERROR: there is no unique constraint matching given keys for referenced table “bar”
  42. Cannot simply use PostgreSQL table name (“relation does not exist”)
  43. Can’t find the ‘libpq-fe.h header when trying to install pg gem
  44. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  45. could not connect to server: No such file or directory (PG::ConnectionBad)
  46. Postgresql tables exists, but getting “relation does not exist” when querying
  47. PG::ConnectionBad: fe_sendauth: no password supplied
  48. “extra data after last expected column” while trying to import a csv file into postgresql
  49. postgresql: error duplicate key value violates unique constraint
  50. psql: command not found Mac
  51. pg_ctl: no database directory specified and environment variable PGDATA unset
  52. psql: FATAL: role “postgres” does not exist
  53. Postgres Error: More than one row returned by a subquery used as an expression
  54. PostgreSQL: Query has no destination for result data
  55. What is the difference between LATERAL JOIN and a subquery in PostgreSQL?
  56. PostgreSQL create table if not exists
  57. updating table rows in postgres using subquery
  58. PostgreSQL visual interface similar to phpMyAdmin?
  59. java.lang.ClassNotFoundException: org.postgresql.Driver, Android
  60. GROUP BY and COUNT using ActiveRecord
  61. Postgresql column reference “id” is ambiguous
  62. What is a postgres superuser
  63. GRANT SELECT to all tables in postgresql
  64. Is there an equivalent of MySQL’s SHOW CREATE TABLE in Postgres?
  65. Postgres equivalent to MySQL’s \G?
  66. Postgresql: what does GRANT ALL PRIVILEGES ON DATABASE do?
  67. Postgres equivalent to MySQL’s \G?
  68. Postgres equivalent to MySQL’s \G?

Leave a Comment