thats just what i needed to know.
many many thanks!
j.
-Original Message-
From: Rod Taylor [mailto:[EMAIL PROTECTED]
Sent: 24 October 2003 19:01
To: Julian North
Cc: [EMAIL PROTECTED]
Subject: Re: naming conventions constraint
rbt=# create table bob_is(your_uncle integer, constraint
"
rbt=# create table bob_is(your_uncle integer, constraint
"bob_is#your_uncle" check(true));
CREATE TABLE
rbt=# \d bob_is
Table "public.bob_is"
Column | Type | Modifiers
+-+---
your_uncle | integer |
Check constraints:
"bob_is#your_uncle" CHECK true
Yo
I'm at the very beginning of working with postgres.
The aim is to replace / build a number of very large and very complex
database currently residing in Oracle, MSSQL and Informix.
In order to coordinate across a medium size DBA team I instituted a standard
constraint naming convention suitable f