Re: Double Quoting Table Names???? - Mailing list pgsql-general

From Mike Mascari
Subject Re: Double Quoting Table Names????
Date
Msg-id 3BB212B4.353577D5@mascari.com
Whole thread Raw
In response to Double Quoting Table Names????  (Edward Muller <edwardam@home.com>)
List 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@mascari.com

pgsql-general by date:

Previous
From: Arcady Genkin
Date:
Subject: Authenticating user `postgres'
Next
From: "Dale Anderson"
Date:
Subject: PgAdmin for 7.1.3