Re: Double Quoting Table Names????

Good point. I think that SQL Server does this as well. Reason is to preserve
any spaces or capital letters in the table names. Ugh!

Wes

Mike Mascari <mascarm%mascari(dot)com(at)interlock(dot)lexmark(dot)com> on 09/26/2001 01:39:00
PM

To: Edward Muller <edwardam%home(dot)com(at)interlock(dot)lexmark(dot)com>
cc: pgsql-general%postgresql(dot)org(at)interlock(dot)lexmark(dot)com (bcc: Wesley
Sheldahl/Lex/Lexmark)
Subject: Re: [GENERAL] Double Quoting Table Names????

Edward Muller wrote:
>
> I am using a Postgresql 7.1.2 server and it seems that I need to put ""
> around my table name when doing select queries either using JDBC, PHP or
> the psql interface.
>
> None of the docs that I've looked at indicate that I should need to do
> this.
>
> Can anyone explain this?

How were these tables created? A common cause of this condition is
that Access users use the Export utility to create the tables via
the ODBC driver, and Access issues a CREATE TABLE statement with the
table and column names quoted.

Mike Mascari
mascarm(at)mascari(dot)com

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org