Skip site navigation (1) Skip section navigation (2)

Re: Insert Statement & Composite Type

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Grant Martin" <grantwgmartin(at)live(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Insert Statement & Composite Type
Date: 2012-09-08 15:12:33
Message-ID: 27385.1347117153@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
"Grant Martin" <grantwgmartin(at)live(dot)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


In response to

pgsql-novice by date

Next:From: Steve HornDate: 2012-09-10 01:13:33
Subject: Details of Segmentation Fault
Previous:From: Grant MartinDate: 2012-09-08 08:33:24
Subject: Insert Statement & Composite Type

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group