Home > mailing lists

Serial data type not starting at 1 - Mailing list pgsql-general

From	Tielman J de Villiers
Subject	Serial data type not starting at 1
Date	November 15, 2001 12:10:22
Msg-id	E1F206EC93DCD4119A05009027A4135906499E@sbssvr.bondnet.co.za Whole thread Raw
Responses	Re: Serial data type not starting at 1 Re: Serial data type not starting at 1 Re: Serial data type not starting at 1 Re: Serial data type not starting at 1
List	pgsql-general

Tree view

Hi,

I hope someone can help me.

I want to create a new table using the "automatic" sequence function of
Postgres by creating the first column as type "serial". But I want to start
at say "5000". Can it be done, and how?

Thank you

Tielman J de Villiers
BondNet Pty Ltd

pgsql-general by date:

From: David Ford
Date: 15 November 2001, 11:40:38
Subject: UPDATE w/ subselect doing locking

From: cbbrowne@acm.org
Date: 15 November 2001, 12:11:29
Subject: Re: Sourceforge on Oracle? (WAY OT)

Serial data type not starting at 1 - Mailing list pgsql-general

Previous

Next