Received: from bologna.nettuno.it (bologna.nettuno.it [193.43.2.1]) by hub.org (8.9.2/8.9.1) with ESMTP id KAA53823; Tue, 16 Feb 1999 10:10:58 -0500 (EST) (envelope-from sferac@bo.nettuno.it) Received: from proxy.sferacarta.com (mail@sfcabop1.nettuno.it [193.207.10.213]) by bologna.nettuno.it (8.8.6/8.8.6/NETTuno 3.1) with ESMTP id QAA04495; Tue, 16 Feb 1999 16:10:52 +0100 (MET) Received: from rosso.sferacarta.com (bo.nettuno.it) [10.20.30.5] by proxy.sferacarta.com with esmtp (Exim 2.05 #1 (Debian)) id 10CllF-0001iI-00; Tue, 16 Feb 1999 14:46:05 +0000 Message-ID: <36C97620.12FE717F@bo.nettuno.it> Date: Tue, 16 Feb 1999 14:44:00 +0100 From: "jose' soares" Organization: Sferacarta Software X-Mailer: Mozilla 4.5 [it] (Win95; I) X-Accept-Language: it MIME-Version: 1.0 To: Martin =?iso-8859-1?Q?M=F6derndorfer?= CC: pgsql-sql@postgresql.org, pgsql-general@postgresql.org, pgsql-admin@postgresql.org Subject: Re: [GENERAL] Creating Textfiles out of tables References: <36C96D05.8F6676D8@linux.stuco.uni-klu.ac.at> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Martin Möderndorfer ha scritto: > Hi, > > i have some tables and want to extract results of a query on them into a > text-file. it should be possible to insert ":","{" between the different > tuples. > > Any ideas > > MArtin > mmoedern@linux.stuco.uni-klu.ac.at psql joe joe=> \t turned off output headings and row count joe=> \f : field separator changed to ':' joe=> select * from btmm; a : 13.2:FO b : 1.32:FO c :31.32:RO if you type \o file_name the result will be stored to a file named "file_name". -- - Jose' - And behold, I tell you these things that ye may learn wisdom; that ye may learn that when ye are in the service of your fellow beings ye are only in the service of your God. - Mosiah 2:17 -