Re: Using COPY

Morning Everyone,
I've had good luck with pgadmin II and it's database import wizard as well.
The only problem I had was it wanted to make a memo field a varchar(1).
One minor tweak, and i was able to pull 45 glorious megabytes of Access
data into PG. We're slowly converting over a VB app to use said database,
and it's going really well.
ttfn
corey

-----Original Message-----
From: Bertin, Philippe [SMTP:philippe(dot)bertin(at)barco(dot)com]
Sent: Tuesday, May 14, 2002 8:17 AM
To: tony; joe(at)jwebmedia(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Using COPY

Tony,

Wouldn't the 'simple' way I thought of (i.e., using ODBC and Access
combined) do the trick ?

Regards,

Philippe Bertin.

> -----Original Message-----
> From: tony [SMTP:tony(at)animaproductions(dot)com]
> Sent: dinsdag 14 mei 2002 16:30
> To: joe(at)jwebmedia(dot)com
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Using COPY
>
> On Tue, 2002-05-14 at 16:15, Joseph Koenig wrote:
> > We're converting a db from Access to PostgreSQL for a client - I need
to
> > export all of his data into postgres on Linux - I'm trying to use the
> > COPY command, however, his comment fields have line breaks in them
which
> > causes the copy to throw a parse error at that line. I'm sure others
> > have run into this - is there an easy way to avoid this? Thanks,
>
> Welcome to pain! Now when someone asks me to port data, I bill each and
> every hour spent - no more estimates on how much it will cost!!!
>
> I'm sure someone will recommend a perl script to rip them out.
>
> If you aren't a perl guru then run out and find a Mac with BBEdit which
> is the absolute best text editor in the world. A combination of BBEdit
> and OpenOffice will clean up and format any text file and save it to
> many types of text including CSV.
>
> Cheers
>
> Tony Grant
> --
> RedHat Linux on Sony Vaio C1XD/S
> http://www.animaproductions.com/linux2.html
> Macromedia UltraDev with PostgreSQL
> http://www.animaproductions.com/ultra.html
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org