Thread: exporting table to txt

exporting table to txt

From
Marcos
Date:
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


Re: exporting table to txt

From
"Poul L. Christiansen"
Date:
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