Re: Postgresql and scripting [SOLVED]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

On Wed, 8 Sep 2004, Jerome Lyles wrote:

> Thank you tsarevich that solved it.  I'm trying to 'SELECT' out of the tables
> now but I'm getting another syntax error:-)
>
> test-# SELECT prod_name FROM Products;
> ERROR:  syntax error at or near "SELECT" at character 14

  test-# SELECT prod_name FROM Products;
      ^

The dash indicates that another command before this line has been written 
but not ended with semicolon. An example:

test=# SELECT
test-# SELECT * from datetest ;
ERROR:  syntax error at or near "SELECT" at characte

You should check the previous line.

Regards,

- --
Devrim GUNDUZ 
devrim~gunduz.org				devrim.gunduz~linux.org.tr
 			http://www.tdmsoft.com
 			http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFBP1Z4tl86P3SPfQ4RAlw6AKDmamve8PTNClFWnZh/49QxwcsH8wCeM4G3
fEYyFVT5z8DIw5VNgbBudKM=
=TSSn
-----END PGP SIGNATURE-----