From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | "R(dot)Tichy" <r(dot)tichy(at)sew-eurodrive(dot)at> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [why copy ? its not correct working outside static |
Date: | 2002-05-10 16:12:57 |
Message-ID: | 20020510091131.A39883-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, 10 May 2002, R.Tichy wrote:
> Hallo, erverybody !
>
> I am working with Postgresql 7.2 on cygwin !
>
> I have this problem inside from Database with functions and inside from
> JDBC....
>
> A Example :
>
> create or replace function copy_data (varchar,varchar) returns varchar
> as '
> declare
> aurl ALIAS FOR $1;
> adelim ALIAS FOR $2;
> begin
>
> -- nice its work very fine with static param ...
> copy transimport from ''/home/usrer/imports/trans.txt'';
>
> -- where default \t is fieldseparator don't work with params wy ?
> copy transimport from aurl;
I'm not sure of the details of why this doesn't work, but
it appears you may be able to make this work using EXECUTE.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-05-10 16:39:56 | Re: Subject: bool / vacuum full bug followup part 2 |
Previous Message | Scott Marlowe | 2002-05-10 16:12:48 | Re: trouble with (lack of) indexing |