X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 53E623A3DCE for ; Mon, 17 Jan 2005 18:24:01 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 37678-03 for ; Mon, 17 Jan 2005 18:23:43 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id A2C9F3A3E43 for ; Mon, 17 Jan 2005 18:22:43 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j0HIMfnF004178; Mon, 17 Jan 2005 13:22:41 -0500 (EST) To: Gary.Broadbent@gtnet.com Cc: pgsql-admin@postgresql.org Subject: Re: SQL syntax In-reply-to: References: Comments: In-reply-to "Gary Broadbent" message dated "Mon, 17 Jan 2005 14:05:02 +0000" Date: Mon, 17 Jan 2005 13:22:40 -0500 Message-ID: <4177.1105986160@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/176 X-Sequence-Number: 16035 "Gary Broadbent" writes: > I then tried to do a select: > SELECT * FROM CITIES; > and this did not work. However when I tried > SELECT * FROM "GTX"."CITIES"; > my select statement DID work. > Why are do my select statements work with quotes surrounding the schema and > table although the help does not say that quotes are required? Apparently you created the table with all-upper-case not all-lower-case name. See http://developer.postgresql.org/docs/postgres/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS particularly the last paragraph of that section. regards, tom lane