agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Christine Cullen <apc@inel.gov>
To: postgres@postgres.Berkeley.EDU
Subject: retrieve relation to ascii file  ANSWER
Date: Thu, 28 Apr 94 13:58:13 MDT
Message-ID: <9404281958.AA03138@rosy.inel> (raw)


> 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.
===============================================================================

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: apc@inel.gov
  Subject: Re: retrieve relation to ascii file  ANSWER
  In-Reply-To: <9404281958.AA03138@rosy.inel>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox