Subject: retrieve relation to ascii file ANSWER

From: [email-masked] (Christine Cullen)
Date: Thu, 28 Apr 94 13:58:13 MDT

> From [email-masked] Thu Apr 28 11:02:03 1994
> Date: Thu, 28 Apr 1994 10:04:07 -0700
> From: "Guy R. Thomas" <[email-masked]>
> To: [email-masked] (Christine Cullen)
> Subject: Re: retrieve relation into ascii file
> Content-Length: 1075
> 
> > 
> 
> > Hi!
> > Does anyone know if there is a way perform 
> 
> > a retrieve command and get the result into ASCII
> > file format?  
> 
> > The copy command works very well for entire classes,
> > but I need to retrieve specific relations.
> > Any help is greatly appreciated.
> > Thanks in advance.	
> > Chris 
> 
> > 
> 
> 
> Do a retrieve into a temporary class then do a copy.
> 
> 
> * retrieve into temp_class ( target.list ) where qualification \g
> 
> * copy from temp_class "/path/to/file" \g
> 
>      retrieve
>          [ (into classname [ archive_mode ] |
>             portal portal_name |
>             iportal portal_name ) ]
>          [unique]
>          ( [ attr_name-1 =] expression-1 {, [attr_name-i =] expression-i} )
>          [ from from_list ]
>          [ where qual ]
>          [ sort by attr_name-1 [using operator]
>                { , attr_name-j [using operator] } ]
> 
> 
> 
> ---
> Guy R. Thomas                           Native Education Centre
> Library Coordinator                     285 East Fifth Avenue
> [email-masked]                 Vancouver B. C.
> V:(604) 873-3761 --- F:(604) 873-9152   V5T 1H2
> 

===============================================================================
    To add/remove yourself from the POSTGRES mailing list: send mail with 
    the subject line ADD or DEL to "[email-masked]"

    If this fails, send mail to "[email-masked]" and
    a human will deal with it.  DO NOT post to the "postgres" mailing list.
===============================================================================