Skip site navigation (1) Skip section navigation (2)

Re: simple or global column names?

From: John DeSoi <desoi(at)pgedit(dot)com>
To: gry(at)ll(dot)mit(dot)edu
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: simple or global column names?
Date: 2005-11-08 18:56:26
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
On Nov 8, 2005, at 10:28 AM, george young wrote:

> I.e., should a field in steps be "version" or "step_version"?  On  
> one hand,
> the "step_" prefix is redundant noise in this context, but for  
> doing joins,
> it seems like globally distinct names might make things clearer.
> Are there other advantages/disadvantages to these naming schemes?
> My goals (in this major schema reorganization) are simplicty,  
> clarity, and
> in particular, to facilitate nieve users' read-only ODBC access  
> through
> Excel or other GUI clients.

I find it annoying to read and write column names that are prefixed  
with table names or some variant. It is easy enough to deal with  
joins. Something like

select s.title as "Song Title", b.title as "Book Title" from song s,  
book b ...;

And for read only access, views are an easy way to present whatever  
column titles are the most user friendly.

John DeSoi, Ph.D.
Power Tools for PostgreSQL

In response to

pgsql-novice by date

Next:From: Dmitriy KurilovDate: 2005-11-09 05:25:06
Previous:From: Moravec JanDate: 2005-11-08 16:11:47
Subject: Setting pgsql variable from query result

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group