Pastebin
Paste #1336: pg currval
< previous paste - next paste>
Pasted by tdn
sosms=# SELECT * FROM sms;
smsid | inserttime | updatetime | customerid | msisdnto | msisdnfrom | content | status | callbackid
-------+----------------------------+----------------------------+------------+----------+------------+---------+--------+------------
24 | 2009-06-08 11:49:29.517415 | 2009-06-08 11:49:29.517415 | 10 | foo | bar | foobar | 0 | hest
(1 row)
sosms=# SELECT CURRVAL(pg_get_serial_sequence('sms','smsid'));
currval
---------
(1 row)
sosms=#
New Paste
Go to most recent paste.
