Hi,
i have tried to find info elsewhere, but did not find anything to my satisfaction, so I was wondering if anyone on this list could point me into the right direction.
When I create a table
e.g.:
create table xyz
(
id serial PRIMARY KEY,
uvw varchar2(100)
);
I would like to get the id returned when I insert into this table. In oracle it is possible to do this:
insert into xyz(uvw) values ('Test') returning id;
How can I do this with SQL in Postgres. Any ideas.
Thank you for any suggestions
Mirko