Re: Double Quoting Table Names????

From: wsheldah(at)lexmark(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 16:10:00
Message-ID: 200109261610.MAA07196@interlock2.lexmark.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Does your table name use capital letters, spaces, or SQL reserved words? What's
the name?

Edward Muller <edwardam%home(dot)com(at)interlock(dot)lexmark(dot)com> on 09/26/2001 12:58:01
PM

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

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?

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

http://archives.postgresql.org

Browse pgsql-general by date

  From Date Subject
Next Message Michael 2001-09-26 16:17:30 Re: Perl and Postgres
Previous Message Vic Cekvenich 2001-09-26 16:08:08 JDBC update wont, plz help.