X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 46C32D1B8EA for ; Tue, 23 Sep 2003 14:59:31 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 05818-04 for ; Tue, 23 Sep 2003 11:58:33 -0300 (ADT) Received: from nt-groupware.cabal.com.ar (unknown [200.69.240.4]) by svr1.postgresql.org (Postfix) with ESMTP id D7C7FD1B8EC for ; Tue, 23 Sep 2003 11:58:28 -0300 (ADT) Received: by NT-GROUPWARE with Internet Mail Service (5.5.2653.19) id ; Tue, 23 Sep 2003 11:56:36 -0300 Message-ID: <9B9EF0AE4BCBD21190220008C74C77A903169B5F@NT-GROUPWARE> From: "Montervino, Mariano" To: "'pgsql-sql@postgresql.org'" Subject: Especial delimiters caracter Date: Tue, 23 Sep 2003 11:56:26 -0300 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="ISO-8859-1" X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200309/283 X-Sequence-Number: 15261 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