>
> Thanks for your replay...
> I resolve the problem with sed before i post the question.
> But a really want to know if i can handle all with posgre script.
>
> Mariano
>
No, you cannot. Because copy is also intended to work vice versa
i.e. copy from file to table and therefore the doubled ba
: Montervino, Mariano; '[EMAIL PROTECTED]'
Asunto: Re: [SQL] Especial delimiters caracter
On Tuesday 23 September 2003 15:56, Montervino, Mariano wrote:
> running the following script
>
> select ('cabal\\' || user_name) into temporary user_access from
> tbl_user_access whe
On Wednesday 24 September 2003 18:27, Montervino, Mariano wrote:
> Thanks for your replay...
> I resolve the problem with sed before i post the question.
> But a really want to know if i can handle all with posgre script.
Not really - it's designed that way so you can COPY TO a file on one machine
On Tuesday 23 September 2003 15:56, Montervino, Mariano wrote:
> running the following script
>
> select ('cabal\\' || user_name) into temporary user_access from
> tbl_user_access where access_profile_id = 4;
> copy user_access to '/temp/users.txt' delimiters '|';
>
> The result of the output file
running the following script
select ('cabal\\' || user_name) into temporary user_access from
tbl_user_access where access_profile_id = 4;
copy user_access to '/temp/users.txt' delimiters '|';
The result of the output file is...
domain\\users
but the field in the temp table is...
domain\users
I n
