Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group