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 97CCD3A18BC for ; Mon, 17 Jan 2005 14:08:19 +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 03132-01 for ; Mon, 17 Jan 2005 14:07:59 +0000 (GMT) Received: from mail19.messagelabs.com (mail19.messagelabs.com [193.109.254.3]) by svr1.postgresql.org (Postfix) with SMTP id A948E3A3D0D for ; Mon, 17 Jan 2005 14:08:00 +0000 (GMT) X-VirusChecked: Checked X-Env-Sender: Gary.Broadbent@gtnet.com X-Msg-Ref: server-15.tower-19.messagelabs.com!1105970879!25529953!1 X-StarScan-Version: 5.4.5; banners=gtnet.com,-,- X-Originating-IP: [62.253.177.169] Received: (qmail 1866 invoked from network); 17 Jan 2005 14:07:59 -0000 Received: from unknown (HELO mailhost.grahamtech.co.uk) (62.253.177.169) by server-15.tower-19.messagelabs.com with SMTP; 17 Jan 2005 14:07:59 -0000 Received: from atlantis.inchinnan.grahamtech.co.uk (nat.grahamtech.co.uk [62.253.177.183]) by mailhost.grahamtech.co.uk (Postfix) with ESMTP id B931A118E56 for ; Mon, 17 Jan 2005 14:12:03 +0000 (GMT) Received: from EOS (dhcp159.deployment.inchinnan.grahamtech.co.uk [10.77.41.159]) by atlantis.inchinnan.grahamtech.co.uk (Postfix) with SMTP id 1200E108D0 for ; Mon, 17 Jan 2005 14:07:59 +0000 (GMT) Reply-To: From: "Gary Broadbent" To: Subject: SQL syntax Date: Mon, 17 Jan 2005 14:05:02 -0000 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200501/175 X-Sequence-Number: 16034 Hi, I am testing some integration with PostgreSQL version 8 rc5 but am having trouble with the SQL syntax. The help on pgAdmin III say that the syntax of an insert statement is: INSERT INTO CITIES VALUES ('San Francisco', '(-194.0, 53.0)'); however I am not finding this to work. Instead I receive the error: ERROR: relation "CITIES" does not exist 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? What is the correct syntax for an insert statement? I am also using a JDBC for PostgreSQL but this returns the same errors as I have described above. Regards, Gary. ________________________________________________________________________________ This email (and any attachments) is private and confidential, and is intended solely for the addressee. If you have received this communication in error please remove it and inform us via telephone or email. Although we take all possible steps to ensure mail and attachments are free from malicious content, malware and virii, we cannot accept any responsibility whatsoever for any changes to content outwith our administrative bounds. The views represented within this mail are solely the view of the author and do not reflect the views of Graham Technology as a whole. ________________________________________________________________________________ Graham Technology plc http://www.gtnet.com ________________________________________________________________________________