Restore from plain text 2

[mhaupt]

Hello,
I want to load data into postgre db.
I have a data file in text format but pg_restore doesn't support plain format.
Is there any way to load plain data by pg_restore?
Or is there any way of loading data into db? (for example some utility used for migration from another db to postgre db)

Example of data (two records; two attributes):
1 aa
2 bb

Regards
mhaupt

 

[stefanwagner]

try

\h COPY

in psql, or look here:

http://www.postgresql.org/docs/8.2/static/sql-copy.html

You may have to modify your data first, to generate quotes:

sed -i "s/  /, '/;s/$/'/;" datafile.csv

8, 'aa'
9, 'bb'

copy foo from '/path/to/datafile.csv' WITH delimiter ',';

If you're not used to sed, you could take openoffice.org:calc or some other spreadsheet software, to generate a csv-file.

don't visit my homepage:

http://home.arcor.de/hirnstrom/bewerbung