Re: Good Delimiter for copy command

--- On Thu, 2/12/09, Andrew Gould <andrewlylegould(at)gmail(dot)com> wrote:

> From: Andrew Gould <andrewlylegould(at)gmail(dot)com>
> Subject: Re: [GENERAL] Good Delimiter for copy command
> To: sharmi_jo(at)yahoo(dot)com
> Cc: pgsql-general(at)postgresql(dot)org, "Sam Mason" <sam(at)samason(dot)me(dot)uk>
> Date: Thursday, February 12, 2009, 4:15 PM
> On Thu, Feb 12, 2009 at 2:51 PM, SHARMILA JOTHIRAJAH
> <sharmi_jo(at)yahoo(dot)com>wrote:
>
> > My data fields contains commas, tabs,'|' etc.
> So I cant use t hem as
> > delimiters..so I need a unique may be non-character to
> use as a delimiter...
> > -Sharmila
> >
>
>
> How are you backing up your data? If your backup method
> deals appropriately
> with the characters mentioned above, then backup the data
> and reload them
> into the other tables.

Im not using this for loading postgres data to postgres. Im trying this method to load my Oracle data to postgresql tables.... just trying to migrate my data from oracle to postgresql

Thanks
Sharmila
>
> If your backup method does not deal appropriately with the
> characters you
> mention, you may have larger problems on your hands.
>
> To the list: Does pg_dump escape characters that are the
> same as the
> delimiter?
>
> Thanks,
>
> Andrew