From: Gary Broadbent <Gary.Broadbent@gtnet.com>
To: pgsql-admin@postgresql.org
Subject: SQL syntax
Date: Mon, 17 Jan 2005 14:05:02 -0000
Message-ID: <CJEBKLMOCGBDDFFHIKGDKEDBCDAA.garyb@gtnet.com> (raw)
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
________________________________________________________________________________
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: Gary.Broadbent@gtnet.com
Subject: Re: SQL syntax
In-Reply-To: <CJEBKLMOCGBDDFFHIKGDKEDBCDAA.garyb@gtnet.com>
References: <CJEBKLMOCGBDDFFHIKGDKEDBCDAA.garyb@gtnet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox