Hi,

I have had a look at the docs but, correct me if I am wrong, cannot find a
way to select data into an existing table. I have looked at select into and
copy.

I have a table (called assests):

Id/name/jobno

Where id is a primary key/serial.

What I want to be able to do is:

SELECT name, 3 FROM assets <<INTO>> assets

Since id is a serial/has a default value you don't need to worry about it
(iei the database should take care of it).

Thanks

Jake


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

On Sep 10, 2004, at 3:36 PM, Jake Stride wrote:

I think what you want to do is something along the lines of

INSERT INTO assets (name, jobno)
SELECT distinct name, 3
FROM assets
;

Michael


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org