Re: Serial initial and incremental value

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Serial initial and incremental value
Date: 2015-09-02 09:45:08
Message-ID: ms6gf4$psc$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Willy-Bas Loos 2015-09-02 10:46:40 FDW and BDR
Previous Message Craig Ringer 2015-09-02 09:33:58 Re: BDR setup - bdr_node_join_wait_for_ready()