RE: [GENERAL] MS SQL 7.0 to PostgreSQL 7.1

2001-05-09 Thread Jeff Eckermann
se that in your COPY statement: "COPY table from stdin with null as 'whatever';" > -Original Message- > From: Brent R. Matzelle [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, May 09, 2001 2:40 PM > To: [EMAIL PROTECTED] > Subject: Re: [GENERAL] MS SQL 7.

Re: [GENERAL] MS SQL 7.0 to PostgreSQL 7.1

2001-05-09 Thread Brent R. Matzelle
--- "Ryan C. Bonham" <[EMAIL PROTECTED]> wrote: > My question is what is the best way to import my data from MS > SQL. I > installed the ODBC Drivers and tried exporting using the MS > import/export > tool.. It successfully creates the tables, but fails to import > any data, > with a error stating

[GENERAL] MS SQL 7.0 to PostgreSQL 7.1

2001-05-09 Thread Ryan C. Bonham
Hi, I am looking at PostgreSQL as an alternative to Microsoft SQL. I have a database I would like to move to PostgreSQL to test how long it will take to move files, how to best change our software to access Postgre, etc.. I have PostgreSQL setup on a Test machine running Redhat 7.1. I have Postgr