Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to quietly increment a SEQUENCE?

How to quietly increment a SEQUENCE?

From
"Martin Kresse"
Date:
Hi there,

How can I (quietly) increment a SEQUENCE without having to use 
SELECT, or is there a way to dump the result of a query (SELECT 
NEXTVAL('...'))?

Thanks for your help, Martin Kresse

Re: [SQL] How to quietly increment a SEQUENCE?

From
Bruce Momjian
Date:
> Hi there,
> 
> How can I (quietly) increment a SEQUENCE without having to use 
> SELECT, or is there a way to dump the result of a query (SELECT 
> NEXTVAL('...'))?

SELECT next_val('seqname');


--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026