Postgres Pro
Downloads
Home   >   mailing lists

Re: INSERTing values from usertypes how-to? - Mailing list pgsql-sql

From Tom Lane
Subject Re: INSERTing values from usertypes how-to?
Date
Msg-id 12063.1146155665@sss.pgh.pa.us
Whole thread Raw
In response to INSERTing values from usertypes how-to?  (Mario Splivalo <mario.splivalo@mobart.hr>)
List pgsql-sql
Tree view 
Mario Splivalo <mario.splivalo@mobart.hr> writes:
> Comming back after SELECTing into usertypes, is there a nice way to
> insert data into table from usertype, in a nice way?

Tryinsert into tblA values (insert_tblA.*);

This works in CVS HEAD at least, not sure how far back.
        regards, tom lane

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: any one can help me how to get multiple rows in postgresql
Next
From: Andreas Haumer
Date:
Subject: Re: Porting application with rules and triggers from PG 7.4.x