Vector
Reputation: 77
how to create type using specified schema in postgresql?
I want to create a type or sequence with my owner schema, but when I create, it always in public schema. what should I do? Can you help me ?
Upvotes: 0
Views: 1217
Answers (1)
kriszb12
Reputation: 3
CREATE TYPE my_schema.my_type as ENUM ('yes', 'no', 'maybe');
So basically you put the schema name before the type name and separate them with a dot.
Upvotes: 0
Related Questions
- Postgresql: how to create types in postgresql
- PostgreSQL: Create schema in specific database
- Defining Data Type for Postgres Table Question
- How to create TYPE in PostgreSQL?
- Create a type if not exist Postgresql
- How to select schema to create table in PostgreSQL
- Postgresql Creating a Schema with tables in it
- Create a table of two types in PostgreSQL
- using schemas in postgresql
- Postgres Creating Schema in a specific database