Especial delimiters caracter

From: "Montervino, Mariano" <montervi(at)cabal(dot)com(dot)ar>
To: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: Especial delimiters caracter
Date: 2003-09-23 14:56:26
Message-ID: 9B9EF0AE4BCBD21190220008C74C77A903169B5F@NT-GROUPWARE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 need the same result like temp table. How could i do it??
RGDS

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-09-23 15:15:09 Re: pl/pgsql, cursors and C function
Previous Message Tomasz Myrta 2003-09-23 11:41:00 pl/pgsql, cursors and C function