| From: | Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> |
|---|---|
| To: | "pgsql-general (at) postgresql (dot) org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Sequence name with SERIAL type |
| Date: | 2003-12-17 09:46:31 |
| Message-ID: | 20031217094631.A31451@bacon |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 17/12/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 ???
You could try something like
myfield integer default nextval('mysequence')
where you have previously created the sequence mysequence.
HTH
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marek Lewczuk | 2003-12-17 09:58:06 | Re: md5 function |
| Previous Message | Michael Fuhr | 2003-12-17 09:45:55 | Re: md5 function |