[SQL] How to excute dynamically a generated SQL command?

2009-01-03 Thread John Zhang
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

Re: [SQL] Question on Escape-string

2009-01-03 Thread Steve Midgley
At 05:20 AM 1/1/2009, pgsql-sql-ow...@postgresql.org wrote: To: pgsql-sql@postgresql.org Subject: Question on Escape-string X-Archive-Number: 200812/132 X-Sequence-Number: 32082 Dear all, I am using pl/pgsql to develop a function to implement some logic to load BLOB data, like .tif file, to po