Especial delimiters caracter

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

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-general by date

  From Date Subject
Next Message Joshua D. Drake 2003-09-23 14:52:02 Re: [GENERAL] PostgreSQL query failed: ERROR: pg_atoi: zero-length
Previous Message Egor Shipovalov 2003-09-23 14:46:11 How to get the total number of rows returned by query when using a cursor?