Return-Path: owner-postman
Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id WAA23165 for postgres-redist; Sat, 11 Feb 1995 22:00:54 -0800
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199502120600.WAA23165@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from louie.udel.edu (mmdf@louie.udel.edu [128.175.7.39]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id WAA23155 for <postgres@postgres.berkeley.edu>; Sat, 11 Feb 1995 22:00:18 -0800
Received: from snow-white-fddi.udel.edu by louie.udel.edu id aa05916;
          12 Feb 95 0:57 EST
Received: from stimpy.eecis.udel.edu by snow-white.ee.udel.edu id aa17712;
          12 Feb 95 0:56 EST
Date: Sun, 12 Feb 95 0:56:06 EST
From: Pconrad@eecis.udel.edu
To: postgres@postgres.Berkeley.EDU
cc: pconrad@eecis.udel.edu
Subject: Utility for tab_separated_text
Message-ID: <9502120556.aa12270@stimpy.eecis.udel.edu>
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Sat, 11 Feb 95 22:00:34 -0800
Resent-XMts: smtp

Hi all,
   I am working on a project where I will have a need for a utility
that will take an arbitrary Postquel query and return the result as
tab separated text, suitable for importing into (for example) a
spreadsheet.   
   I know that the "Copy" command will copy an entire class into
a tab separated file.  However, the relations I will be working with
may grow quite large, and so it would be much more convenient to not
have to edit down the rows and columns of a complete dump.
   Before I go about writing such a thing:

1) Does anybody already have such a beast written?  

2) Or, failing that code scraps (beyond the examples in the
   std. postgres distribution) that might be helpful?

3) Or, failing that, just helpful advice for a neophyte in working with
   postgres, attempting his first libpq programming project?

Thanks for your help

--Phill Conrad					      pconrad@cis.udel.edu
--Ph. D. Student -- Dept. of Computer and Info. Science -- Univ. of Delaware

(PS: A related utility, or perhaps a command switch? would be to write
out the results of a query to a LaTeX {tabular} environment, with column
headings=the attribute names.)



==============================================================================
   To add/remove yourself to/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.
==============================================================================
              URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/