enforce naming convention - Mailing list pgsql-general

From SunWuKung
Subject enforce naming convention
Date
Msg-id 1145094934.715462.298290@v46g2000cwv.googlegroups.com
Whole thread Raw
Responses Re: enforce naming convention
List 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


pgsql-general by date:

Previous
From: Kari Pahula
Date:
Subject: Re: Curious UDP packets
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: enforce naming convention