Return-Path: owner-postman Delivery-Date: Thu, 28 Apr 94 16:29:54 -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 NAA17972 for postgres-redist; Thu, 28 Apr 1994 13:01:59 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199404282001.NAA17972@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 NAA17961 for ; Thu, 28 Apr 1994 13:01:58 -0700 Received: from rosy.inel (rosy.INEL.GOV) by mica.inel.gov (4.1/INEL-MH-10.0) id AA05848; Thu, 28 Apr 94 14:01:56 MDT Received: by rosy.inel (4.1/SMI-4.1) id AA03141; Thu, 28 Apr 94 13:59:29 MDT Date: Thu, 28 Apr 94 13:59:29 MDT From: apc@inel.gov (Christine Cullen) Message-Id: <9404281959.AA03141@rosy.inel> To: postgres@postgres.Berkeley.EDU Subject: retrieve relation into ascii file ANSWER Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Thu, 28 Apr 94 13:01:59 -0700 Resent-XMts: smtp 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 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. ===============================================================================