agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedFrom: Christine Cullen <apc@inel.gov>
To: postgres@postgres.Berkeley.EDU
Subject: retrieve relation into ascii file ANSWER
Date: Thu, 28 Apr 94 13:59:29 MDT
Message-ID: <9404281959.AA03141@rosy.inel> (raw)
Thanks everyone for your help!!!!
This is working great.
----- Begin Included Message -----
From priester@student.msu.edu Thu Apr 28 13:49:16 1994
From: Mark Victor Priester <priester@student.msu.edu>
Subject: Postgres Question
To: apc@inel.gov
Date: Thu, 28 Apr 1994 15:52:04 -0400 (EDT)
X-Mailer: ELM [version 2.4 PL22]
Content-Type: text
Content-Length: 1035
>| 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
I am not sure that I interpreted your question correctly but...how 'bout
*retrieve into tmp (CLASS.itemofinterest1, CLASS.intemofinterest2)
where CLASS.compare = testvalue\g
*copy tmp to stdout\g
If this does what you want perhaps you could send it to the list,
Mark
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
_/ Mark Priester _/ Phone: 517.694.4789 _/
_/ Barros Research Institute _/ Fax: 517.694.4788 _/
_/ 2430 College Road _/ Internet: priester@student.msu.edu _/
_/ Holt, MI 48842 _/ priester@m-net.ann-arbor.mi.us _/
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
----- End Included Message -----
===============================================================================
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 into ascii file ANSWER
In-Reply-To: <9404281959.AA03141@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