Re: [SQL] naming conventions constraint

2003-10-25 Thread Julian North
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 "

Re: [SQL] naming conventions constraint

2003-10-24 Thread Rod Taylor
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

[SQL] naming conventions constraint

2003-10-24 Thread Julian North
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