Re: SQL problem?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: operationsengineer1(at)yahoo(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: SQL problem?
Date: 2005-08-26 02:21:21
Message-ID: 20050826022121.GA19274@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Thu, Aug 25, 2005 at 16:47:54 -0700,
operationsengineer1(at)yahoo(dot)com wrote:
> > Column names are case-sensitive.
> > Btw.: SELECT * is evil...
> >
> >
> >
> > Regards, Andreas.
>
> Andreas, what would you recommend instead of SELECT *
> if you really do wanty all the results?

Explicitly listing the columns. Using '*' causes maintainance problems.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2005-08-26 04:17:09 Re: Copy Failure
Previous Message operationsengineer1 2005-08-25 23:47:54 Re: SQL problem?