enforce naming convention

From: "SunWuKung" <Balazs(dot)Klein(at)t-online(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: enforce naming convention
Date: 2006-04-15 09:55:34
Message-ID: 1145094934.715462.298290@v46g2000cwv.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
is it possible to enforce naming convention in pg?

Can I create a trigger that runs when a new object is created and see
if its name is in an expected format and if not reject it?

I had to create a new schema 'zref' storing some of our tables to
conceptually separate them but I want to make sure that when we create
new tables we can't have the same table name in 'zref' and 'public'.

Thanks for the help.
Balázs

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Sabino Mullane 2006-04-15 13:20:15 Re: enforce naming convention
Previous Message Kari Pahula 2006-04-15 09:50:49 Re: Curious UDP packets