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.
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
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2005-01-17 16:01:20|
|Subject: Re: closed connection unexpectedly |
|Previous:||From: Robert D Oden||Date: 2005-01-17 11:20:56|
|Subject: closed connection unexpectedly|