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