Postgres Pro
Downloads
Home   >   mailing lists

Re: Insert Statement & Composite Type - Mailing list pgsql-novice

From Tom Lane
Subject Re: Insert Statement & Composite Type
Date
Msg-id 27385.1347117153@sss.pgh.pa.us
Whole thread Raw
In response to Insert Statement & Composite Type  ("Grant Martin" <grantwgmartin@live.com>)
List pgsql-novice
Tree view 
"Grant Martin" <grantwgmartin@live.com> writes:
>     What is the correct INSERT statement syntax to insert a composite
>     type into a table of that type.

This should work:

    INSERT INTO licencee VALUES(new_licencee.*);

            regards, tom lane

pgsql-novice by date:

Previous
From: "Grant Martin"
Date:
Subject: Insert Statement & Composite Type
Next
From: Steve Horn
Date:
Subject: Details of Segmentation Fault