I have a Postgres server with multiple databases (e.g DB1, DB2, DB3)

I need to create a schema sch1 in only DB2. How can I do that?

I have tried connect DB2, but it is not working

closed as unclear what you're asking by a_horse_with_no_name, Andriy M, Philᵀᴹ, mustaccio, Daniel Vérité Oct 17 '16 at 13:41

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.


Lets say the database we will be using called test, then we have to connect to the database first then create schema, example below

\connect test;

Not the answer you're looking for? Browse other questions tagged or ask your own question.