On Thu, Aug 28, 2008 at 10:14 AM, Masis, Alexander (US SSA)
> I was mapping C++ application code that works with mySQL to work with
> There were a number of articles on line regarding the conversion from
> mySQL to Postgres like:
> Well, in MySQL it's easy you just do:
> "SELECT LAST_INSERT_ID();"
> In Postgres, however it is not that simple. You have to know the
> name of so called "insert sequence". Postgres has a system function for
> that( SQL line below ).
> In Postgres you will have to provide the table and column name(
> "auto_increment" type in MySQL or "serial or bigserial" in Postgres).
> Here is that SQL query that returns the last inserted ID:
> "SELECT CURRVAL(
That's the hard way. Starting with pgsql 8.2 you can do it much more easily:
create table tester (id serial primary key, info text);
insert into tester (info) values ('this is a text string') returning id;
tada! All done, that insert will return the id for you.
In response to
pgsql-general by date
|Next:||From: Dave Page||Date: 2008-08-28 19:11:45|
|Subject: Re: temp schemas|
|Previous:||From: Scott Marlowe||Date: 2008-08-28 19:06:55|
|Subject: Re: importing dates|