| 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: | Whole Thread | Raw Message | 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 |