Get last id in postgresql
| From: | Norma Ramirez - TECNOSOFT | Date: | Tue, 17 Jun 2003 02:13:14 +0000 |
| Subject: | Get last id in postgresql | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-28659@lists.php.net to get a copy of this message | ||
Hi all,
I´m starting with posgresql and i trying to use pg_last_oid to get the last id in a insert query,
but this function returns me a big number
like 21318 and bigger, but the table just have 3 or 4 records. Could some one help? Any ideas?
This is the script i´m using
$insert = "insert into test(name) values('myname')";
$test = pg_exec($insert);
echo $id = pg_last_oid($test);
Norma Ramirez
norma.ramirez@tecnosoft.com.co