Re: Win32 Install

From: "Thomas D(dot) Dean" <tomdean(at)ix(dot)netcom(dot)com>
To: martin(at)math(dot)unl(dot)edu(dot)ar
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: Win32 Install
Date: 2000-04-17 17:33:07
Message-ID: 200004171733.KAA03280@ix.netcom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2000-04-17 18:04:21 Re: excell to postgres
Previous Message Ross J. Reedstrom 2000-04-17 17:29:09 Re: excell to postgres