Postgres Pro
Downloads
Home   >   mailing lists

Thread: Serial initial and incremental value

Serial initial and incremental value

From
"FarjadFarid\(ChkNet\)"
Date:

Sorry folks,

 

I should have included this in my last question.

 

How can I obtain the initial and incremental value of a serial entity?

 

Many thanks

 

Best Regards

 

Farjad Farid

Re: Serial initial and incremental value

From
Thomas Kellerer
Date:
FarjadFarid(ChkNet) schrieb am 02.09.2015 um 11:05:
> How can I obtain the initial and incremental value of a serial entity?


You can use:


  select *
  from sequence_name;


where "sequence_name" is the name of the sequence associated with your column.


Thomas