Return-Path: owner-postman 
Delivery-Date: Thu, 28 Apr 94 18:50:26 -0700
Return-Path: owner-postman
Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id NAA17946 for postgres-redist; Thu, 28 Apr 1994 13:00:43 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199404282000.NAA17946@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from mica.inel.gov (mica.inel.gov [134.20.8.7]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id NAA17936 for <postgres@postgres.berkeley.edu>; Thu, 28 Apr 1994 13:00:42 -0700
Received: from rosy.inel (rosy.INEL.GOV) by mica.inel.gov
	(4.1/INEL-MH-10.0) id AA05761; Thu, 28 Apr 94 14:00:40 MDT
Received: by rosy.inel (4.1/SMI-4.1)
	id AA03138; Thu, 28 Apr 94 13:58:13 MDT
Date: Thu, 28 Apr 94 13:58:13 MDT
From: apc@inel.gov (Christine Cullen)
Message-Id: <9404281958.AA03138@rosy.inel>
To: postgres@postgres.Berkeley.EDU
Subject: retrieve relation to ascii file  ANSWER
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Thu, 28 Apr 94 13:00:43 -0700
Resent-XMts: smtp


> From gthomas@native-ed.bc.ca Thu Apr 28 11:02:03 1994
> Date: Thu, 28 Apr 1994 10:04:07 -0700
> From: "Guy R. Thomas" <gthomas@native-ed.bc.ca>
> To: apc@inel.gov (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
> gthomas@native-ed.bc.ca                 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 "postgres-request@postgres.Berkeley.EDU"

    If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
    a human will deal with it.  DO NOT post to the "postgres" mailing list.
===============================================================================