On 2009-02-12, SHARMILA JOTHIRAJAH wrote:
>
> 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
dump as CSV, properly implemented CSV isn't daunted by , " or
On 2009-02-12, SHARMILA JOTHIRAJAH wrote:
> --0-1509090113-1234471898=:21817
> Content-Type: text/plain; charset=iso-8859-1
> Content-Transfer-Encoding: quoted-printable
>
> My data fields contains commas, tabs,'|'=A0 etc. So I cant use them as del=
> imiters..so I need a unique may be non-charact
David Fetter writes:
> On Tue, Feb 17, 2009 at 05:17:40PM +0100, Marco Colombo wrote:
>> Is it possibile to use some unicode character which is unlikely to
>> appear in the data set as delimiter? Something like U+FFFC.
> No. The delimiter needs to be one byte long at the moment. The error
> mes
Tom Lane wrote:
> Andrew Gould writes:
>> To the list: Does pg_dump escape characters that are the same as the
>> delimiter?
>
> Yes. The OP has not actually explained why he needs to pick a
> nondefault delimiter, unless maybe it is that he wants to feed the
> dump to some program that is too
On Tue, Feb 17, 2009 at 05:17:40PM +0100, Marco Colombo wrote:
> Tom Lane wrote:
> > Andrew Gould writes:
> >> To the list: Does pg_dump escape characters that are the same as the
> >> delimiter?
> >
> > Yes. The OP has not actually explained why he needs to pick a
> > nondefault delimiter, unl
On Tue, 2009-02-17 at 17:17 +0100, Marco Colombo wrote:
>
> Which makes me wonder, does copy accept UTF-8 input? Is it possibile
> to use some unicode character which is unlikely to appear in the data
> set as delimiter? Something like U+FFFC.
I'm also not able to get unicode characters to copy
On Thu, 12 Feb 2009, SHARMILA JOTHIRAJAH wrote:
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
The point other posts here were trying to make to you is that
On Thu, 2009-02-12 at 12:51 -0800, SHARMILA JOTHIRAJAH 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
Is this a theoretical problem or an actual one? I haven't had any
Andrew Gould writes:
> To the list: Does pg_dump escape characters that are the same as the
> delimiter?
Yes. The OP has not actually explained why he needs to pick a
nondefault delimiter, unless maybe it is that he wants to feed the
dump to some program that is too dumb to deal with escaping.
--- On Thu, 2/12/09, Andrew Gould wrote:
> From: Andrew Gould
> Subject: Re: [GENERAL] Good Delimiter for copy command
> To: sharmi...@yahoo.com
> Cc: pgsql-general@postgresql.org, "Sam Mason"
> Date: Thursday, February 12, 2009, 4:15 PM
> On Thu, Feb 1
On Thu, Feb 12, 2009 at 2:51 PM, SHARMILA JOTHIRAJAH 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 appropri
On 12/02/2009 20:51, SHARMILA JOTHIRAJAH 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...
Indeed you do... and a quick RTFM reveals that you can set a character
of your choice:
http://
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
--- On Tue, 2/10/09, Sam Mason wrote:
From: Sam Mason
Subject: Re: [GENERAL] Good Delimiter for copy command
To: pgs
On Tue, Feb 10, 2009 at 07:07:42AM -0800, SHARMILA JOTHIRAJAH wrote:
> What is a good delimiter to use for COPY command. Im trying to use
> COPY command to copy data from one table to another in 2 different
> databases.
> Can you suggest a unique delimiter that I can use for this COPY command
If y
Hi,
What is a good delimiter to use for COPY command. Im trying to use COPY command
to copy data from one table to another in 2 different databases.
Can you suggest a unique delimiter that I can use for this COPY command
Thanks
Sharmial
15 matches
Mail list logo
