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
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 |