Re: Double Quoting Table Names????

From: Mike Mascari <mascarm(at)mascari(dot)com>
To: Edward Muller <edwardam(at)home(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Double Quoting Table Names????
Date: 2001-09-26 17:39:00
Message-ID: 3BB212B4.353577D5@mascari.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Svenne Krap 2001-09-26 18:14:46 Re: Birthsday list
Previous Message Arcady Genkin 2001-09-26 17:35:48 Authenticating user `postgres'