Re: [GENERAL] Stored Procedure: Copy table from; path = text variable

2007-07-04 Thread Dave Page
Richard Huxton wrote: Dave Page wrote: Richard Huxton wrote: Charles Pare wrote: Wow, it works great Thank's for the quick answer 12 minutes? I've seen bug-patches turned around quicker than that by Tom ;-) Yeah, that's really quite disappointing Richard - you need to pull your socks up

[GENERAL] Stored Procedure: Copy table from; path = text variable

2007-07-03 Thread Charles Pare
Hi, in a stored procedure, if I do COPY table FROM 'mypath' DELIMITERS '\t'; it works but if my path is a text variable which contain my path, i.e.COPY table FROM mytextvar DELIMITERS '\t'; it doesn't work, I get ERROR: syntax error at or near $1SQL state: 42601Context: SQL statement in

Re: [GENERAL] Stored Procedure: Copy table from; path = text variable

2007-07-03 Thread Richard Huxton
Charles Pare wrote: Hi, in a stored procedure, if I do COPY table FROM 'mypath' DELIMITERS '\t'; it works but if my path is a text variable which contain my path, i.e.COPY table FROM mytextvar DELIMITERS '\t'; it doesn't work, I get ERROR: syntax error at or near $1SQL state: 42601Context: SQL

Re: [GENERAL] Stored Procedure: Copy table from; path = text variable

2007-07-03 Thread Charles Pare
Wow, it works greatThank's for the quick answerThe Postgres community is amazing!Charles Date: Tue, 3 Jul 2007 20:01:03 +0100 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: pgsql-general@postgresql.org Subject: Re: [GENERAL] Stored Procedure: Copy table from; path = text variable Charles

Re: [GENERAL] Stored Procedure: Copy table from; path = text variable

2007-07-03 Thread Richard Huxton
Charles Pare wrote: Wow, it works great Thank's for the quick answer 12 minutes? I've seen bug-patches turned around quicker than that by Tom ;-) The Postgres community is amazing! Mostly by volunteers helping out on lists :-) There's always someone out there you can lend a helping hand

Re: [GENERAL] Stored Procedure: Copy table from; path = text variable

2007-07-03 Thread Dave Page
Richard Huxton wrote: Charles Pare wrote: Wow, it works great Thank's for the quick answer 12 minutes? I've seen bug-patches turned around quicker than that by Tom ;-) Yeah, that's really quite disappointing Richard - you need to pull your socks up :-) /D ---(end

Re: [GENERAL] Stored Procedure: Copy table from; path = text variable

2007-07-03 Thread Richard Huxton
Dave Page wrote: Richard Huxton wrote: Charles Pare wrote: Wow, it works great Thank's for the quick answer 12 minutes? I've seen bug-patches turned around quicker than that by Tom ;-) Yeah, that's really quite disappointing Richard - you need to pull your socks up :-) Would have been