0

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

2

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;
CREATE SCHEMA sch1;
| improve this answer | |

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