Re: Table and Field namestyle best practices?

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Table and Field namestyle best practices?
Date: 2006-11-08 18:39:24
Message-ID: 200611081139.24575.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday November 8 2006 11:31 am, novnov wrote:
> Yes, I've already pretty much decided to use lowercase for all
> namestyles, I mentioned that in the first post. Using
> lowercase invokes a set of other issues, which I'm asking for
> options on...namely, conventions like org_id, and emp_org_id,
> or simply using org_id as the fk pointer.

Not sure there is a "best" way, but I prefer org_id due to
brevity and no concern for quoting. Your emp_org_id is nice for
views because you don't have to disambiguate columns.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Talha Khan 2006-11-08 19:09:36 Re: 8.1.2 postmaster died
Previous Message Alexander Staubo 2006-11-08 18:37:32 Re: Table and Field namestyle best practices?