Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

postgres create type

# Create ENUM type
CREATE TYPE payment_type AS ENUM ('CARD', 'PAYPAL');

# Create type that returns multiple values
CREATE TYPE film_type AS (
    film_id INT,
    title VARCHAR,
    release_year SMALLINT
); 
Source by www.postgresql.org #
 
PREVIOUS NEXT
Tagged: #postgres #create #type
ADD COMMENT
Topic
Name
7+9 =