Re: PostgreSQL SELECT error

From: caldodge(at)fpcc(dot)net (Calvin Dodge)
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: PostgreSQL SELECT error
Date: 2002-01-01 23:50:06
Message-ID: ca6275f0.0201011550.73371680@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Juan Riera" <juanriera(at)hotmail(dot)com> wrote in message news:<a050ee$9bi$1(at)news(dot)tht(dot)net>...
> It works - thanks, Lee
> However I don't understand what happened as I have created this table
> through W98/ODBC from Approach and I did not put explicitly any quotes on
> variables. Maybe Approach does it? Can I eliminate this quotes from column
> names and put names in small caps?

Well, if you're not constantly recreating the table, why not rename the columns?

Something like:

Alter table previs rename "CDART" to cdart;

Calvin

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-01-02 03:36:53 Re: [SQL] An easy question about creating a primary key
Previous Message Shamik Majumder 2002-01-01 11:51:12 Need help