postgres set default schema 1

postgres set default schema

SET search_path TO schema_name;

Here is what the above code is Doing:
1. We’re creating a new schema called “schema_name”
2. We’re setting the search path to “schema_name”
3. We’re creating a new table called “table_name”
4. We’re inserting a row into the table
5. We’re selecting the row from the table
6. We’re dropping the table
7. We’re dropping the schema

Similar Posts