Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group