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: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

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:
and this did not work. However when I tried
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                     


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-2017 The PostgreSQL Global Development Group