Re: Creating Text Files from Tables

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Creating Text Files from Tables
Date: 2006-02-10 14:17:31
Message-ID: 20060210141731.GA9847@webserv.wug-glas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

am 10.02.2006, um 7:06:52 -0600 mailte Warren Murray folgendes:
> This maybe be on a more complex side, but I'm a novice to say the least, how
> can I export a text delimited file from Postgresql. The file will be
> transferred into a specific directory for use with another system. text
> file row sample: 396,"bigshoes.blue.7"
>
> My last question is how can I create a series of fixed-width text files from
> tables and/or queries in a Postgresql database?

You can use untrusted languages such as plperlu for this.

HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47215, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message John DeSoi 2006-02-10 15:06:58 Re: Creating Text Files from Tables
Previous Message Warren Murray 2006-02-10 13:06:52 Creating Text Files from Tables