Re: Table and Field namestyle best practices? - Mailing list pgsql-general

From Ed L.
Subject Re: Table and Field namestyle best practices?
Date
Msg-id 200611081139.24575.pgsql@bluepolka.net
Whole thread Raw
In response to Re: Table and Field namestyle best practices?  (novnov <novnovice@gmail.com>)
List 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.

pgsql-general by date:

Previous
From: Alexander Staubo
Date:
Subject: Re: Table and Field namestyle best practices?
Next
From: "Talha Khan"
Date:
Subject: Re: 8.1.2 postmaster died