Menu
Does anybody know how to switch between PostgreSQL databases or schemas in DataGrip (The Database IDE from JetBrains) in the console?
i can do that in Mysql by using:
Use my_database;
I tried using the Psql methods like
\connect
or
\c
but nothing works.
And could not find anyting in DataGrip Help page.
961
We can switch between the databases in PostgreSQL using \c or \connect metacommand, which creates a new connection and closes the current one.
The same object name can be used in different schemas without conflict; for example, both schema1 and myschema can contain tables named mytable . Unlike databases, schemas are not rigidly separated: a user can access objects in any of the schemas in the database they are connected to, if they have privileges to do so.
1. A database in PostgreSQL contains the subset of schema. It contains all the schemas, records, and constraints for tables. A Schema in PostgreSQL is basically a namespace that contains all the named database objects like tables, indexes, data types, functions, stored procedures, etc.
If you speaking about the code, use SET search_path TO my_schema, public;
If you speaking about the tool, DataGrip, use switcher:
87
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
