Re: Copy function syntax on 8.1

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Mike G(dot)" <mike(at)thegodshalls(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Copy function syntax on 8.1
Date: 2005-08-30 22:57:14
Message-ID: 200508302257.j7UMvEc16673@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Mike G. wrote:
> Thank you.
>
> Perhaps this should be added to the TODO list? New section specifically
> for issues related to this?

I think our current documentation/release notes are clear on this point.

---------------------------------------------------------------------------

>
> Mike
>
> On Tue, Aug 30, 2005 at 01:54:56PM -0400, Tom Lane wrote:
> > "Mike G." <mike(at)thegodshalls(dot)com> writes:
> > > On the non windows platforms you can issue the copy statement and the file path syntax is exactly the same as if you were changing directories in a shell. No special escaping or syntax is needed.
> > > It would be nice if the same could be done for those forced to use windows.
> >
> > Well, that's one reason why we are migrating towards backslashes not
> > being special in strings. It's going to take awhile to get there,
> > though, because we can't just change it without a lot of advance notice.
> > There are too many programs that would break.
> >
> > regards, tom lane
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 9: In versions below 8.0, the planner will ignore your desire to
> > choose an index scan if your joining column's datatypes do not
> > match
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message operationsengineer1 2005-08-30 22:58:40 Sorting Challenge
Previous Message operationsengineer1 2005-08-30 22:27:15 Re: Copy Failure