Inserting a custom Postgres datatype with PHP

Question

CREATE TYPE mpaa_rating AS ENUM (
    'G',
    'PG',
    'PG-13'
);

CREATE TABLE film (
    film_id integer DEFAULT nextval('film_film_id_seq'::regclass) NOT NULL,
    rating mpaa_rating DEFAULT 'G'::mpaa_rating
);

I've tried the following:

pg_insert($dbconn, "film", new array("rating" => "PG"));
pg_insert($dbconn, "film", new array("rating" => "'PG'::mpaa_rating"));
pg_insert($dbconn, "film", new array("rating" => "PG::mpaa_rating"));

I get the error: unknown or system data type

Good call on use of PG's enums.

rfusca
– rfusca

2010-07-01 03:48:15 +00:00
Commented Jul 1, 2010 at 3:48 — rfusca
– rfusca, Commented Jul 1, 2010 at 3:48

Artefacto · Accepted Answer · 2010-07-01 01:05:26Z

1

pg_query($dbconn, "insert into film(rating) values('PG');");

pg_insert is experimental and has several shortcomings.

answered Jul 1, 2010 at 1:05

Artefacto

98.1k17 gold badges207 silver badges232 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Frank Heikens Over a year ago

Or even better, use pg_query_params().

Collectives™ on Stack Overflow

Inserting a custom Postgres datatype with PHP

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related