Re: exporting table to txt

From: "Poul L(dot) Christiansen" <poulc(at)cs(dot)auc(dot)dk>
To: Marcos <marcos(at)second(dot)ival(dot)es>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: exporting table to txt
Date: 2001-01-15 10:11:02
Message-ID: 3A62CCB6.4030201@cs.auc.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Use the pg_dump utility.

pg_dump -t MyTable MyDatabase>MyFile.sql

See also "man pg_dump".

Poul L. Christiansen

Marcos wrote:

> hi,
>
> i would like to make some changes in the configuration of the fields
> from a table so my first doubt is concerning to keep the info safe. how
> can i export data from my table into a text file separated with tabs?
>
> thanks in advance,
>
> marcos
>
> --
> m a r c o s @ i v a l . e s

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Ansley 2001-01-15 10:35:30 RE: Re: 'Tuple is too big' Error
Previous Message Joerg Hessdoerfer 2001-01-15 09:35:39 Universal B-trees...