Re: Win32 Install - Mailing list pgsql-general

From Thomas D. Dean
Subject Re: Win32 Install
Date
Msg-id 200004171733.KAA03280@ix.netcom.com
Whole thread Raw
In response to RE: Win32 Install  ("Joseph" <lters@mrtc.com>)
List pgsql-general
You should be able to save the excel table as a text file, with a tab
separator.  You may need to use sed to convert the line_end from
windows to unix form.  Then use the psql copy to put the data into the
table.

Use vi to create a to_dos.sh

#! /usr/local/bin/tcsh -f
cat $1 | sed -e 's/$/^M/' > xx

where the ^M is a single character entered with control-v controm-m,

Then use this to convert the text

tomdean

pgsql-general by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: excell to postgres
Next
From: Bruce Momjian
Date:
Subject: Re: excell to postgres