[SQL]

2011-04-20 Thread Humair Mohammed
I am running into a behavior with a postgresql function with a SETOF refcursor's returning multiple columns. Not sure if there is a different way to retrieve a SETOF refcursor's with variable columns? Alternatively can I return a primitive value and a refcursor from the same function. I tried

[SQL] COPY with FORMAT in Postgresql 9.x

2010-12-02 Thread Humair Mohammed
Postgres 9.x provies the COPY command with new syntax with a new option called FORMAT http://www.postgresql.org/docs/current/static/sql-copy.html However when I run the following command: COPY dQstn FROM 'c:/bcp/postgres/dQstn.csv' WITH FORMAT csv; I get the following error message: ERROR: synt