Thread: Another Import text

Another Import text

From
bsabsa@earthlink.net
Date:
How do I import text into a table if the delimiter is varying whitespaces.
Sometimes is a single space, or multiple space, or tabs even?  I've tried

psql  db-name -c "COPY relation-name FROM stdin;" < file-name

but this clumps on the data into a single field.

Thanks in advance
billy


--------------------------------------
E-Mail: bsabsa@earthlink.net
Date: 01-Sep-98
Time: 01:06:19

This message was sent by XFMail (Linux version)
--------------------------------------