Re: Sequence name with SERIAL type - Mailing list pgsql-general

From Richard Huxton
Subject Re: Sequence name with SERIAL type
Date
Msg-id 200312170936.16016.dev@archonet.com
Whole thread Raw
In response to Sequence name with SERIAL type  (Marek Lewczuk <newsy@lewczuk.com>)
List pgsql-general
On Wednesday 17 December 2003 07:59, Marek Lewczuk wrote:
> I'm curious if the default scheme for sequence name (which is created
> with SERIAL data type) can be changed -- currently all sequences are
> named like this: <table_name>_<field_name>_seq -- can it be changed for
> e.g. <table_name>__<field_name>__seq ???

Your two options seem to be:
1. Build your own sequence and don't use SERIAL
2. Change the source (should be a simple change).

--
  Richard Huxton
  Archonet Ltd

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: md5 function
Next
From: Richard Huxton
Date:
Subject: Re: md5 function