Re: Copy function syntax on 8.1 - Mailing list pgsql-novice

From Bruce Momjian
Subject Re: Copy function syntax on 8.1
Date
Msg-id 200508302257.j7UMvEc16673@candle.pha.pa.us
Whole thread Raw
In response to Re: Copy function syntax on 8.1  ("Mike G." <mike@thegodshalls.com>)
Responses Re: Copy function syntax on 8.1  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@thegodshalls.com> writes:
> > > On the non windows platforms you can issue the copy statement and the file path syntax is exactly the same as if
youwere 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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-novice by date:

Previous
From:
Date:
Subject: Re: Copy Failure
Next
From:
Date:
Subject: Sorting Challenge