Skip site navigation (1) Skip section navigation (2)

SQL syntax

From: "Gary Broadbent" <Gary(dot)Broadbent(at)gtnet(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: SQL syntax
Date: 2005-01-17 14:05:02
Message-ID: CJEBKLMOCGBDDFFHIKGDKEDBCDAA.garyb@gtnet.com (view raw or flat)
Thread:
Lists: pgsql-admin
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
________________________________________________________________________________


Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2005-01-17 16:01:20
Subject: Re: closed connection unexpectedly
Previous:From: Robert D OdenDate: 2005-01-17 11:20:56
Subject: closed connection unexpectedly

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group