On Saturday 03 January 2009 5:57:32 pm John Zhang wrote: > Hi the list, > > Referring to the PostgreSQL 8.3 documentation " 38.5.4. Executing Dynamic > Commands ", the command for executing a dynamic command is: > EXECUTE command-string [ INTO [STRICT] target ]; > > > I am to execute an sql statement created dynamically, which is represented > in a variable sSql. > Here is an example: > sSql='INSERT INTO hm_raster.hm_airphotos( file_ext, airphoto) VALUES > ('.tif', lo_import( E''C:\\HM\\Data\\Flightmap.tif'');'
You are missing a ')' Should be VALUES ('.tif', lo_import( E''C:\\HM\\Data\\Flightmap.tif''));'; > EXECUTE sSQL; > > It raises the error as: > ERROR: syntax error at end of input > LINE 1: ...E'C:\\HM\\Data\\Flightmap.tif') > ^ > > I would appreciate a lot if you offer your input. Thanks a lot. > > John -- Adrian Klaver akla...@comcast.net -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql