agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Robert.Patrick@cs.cmu.edu
To: postgres@postgres.Berkeley.EDU
To: Pconrad@eecis.udel.EDU
Cc: pconrad@eecis.udel.EDU
Subject: Re: Utility for tab_separated_text
Date: Mon, 13 Feb 1995 15:18:17 -0500 (EST)
Message-ID: <wjDvu9e00hPeBErV1s@cs.cmu.edu> (raw)
In-Reply-To: <9502120556.aa12270@stimpy.eecis.udel.edu>
References: <9502120556.aa12270@stimpy.eecis.udel.edu>

Excerpts from internet.postgres: 12-Feb-95 Utility for
tab_separated_text Pconrad@eecis.udel.edu (1682)

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

Here's a somewhat crude example (please note that I am not being very
rigorous about error checking).

#include <tmp/libpq.h>
#include <stdio.h>
#include <string.h>

int main(int argc, char *argv[])
{
    int i, j, ncols, nrows;
    char *dbname, query[256]; 
    char *retval, *pstring;
    PortalBuffer *pbuf;

    dbname = argv[0];
    sprintf(query, "retrieve (EMP.all) where EMP.name = \"bob\");

    PQsetdb(dbname);
    pstring= PQexec(query);
    pbuf = PQparray(&(pstring[1]));
    ncols = PQnfieldsGroup(pbuf, 0);
    nrows = PQntuplesGroup(pbuf, 0);

    /* Put the code for opening the file here */

    for (i = 0; i < nrows; i++) {
        char tmpbuf[4096];
        int idx;

        idx = 0;
        for (j = 0; j < ncols; j++) {
            retval = PQgetvalue(pbuf, i, j);
	    sprintf (&(tmpbuf[idx]), "%s\t", retval);
             idx += strlen(retval) + 1;
        }
        tmpbuf[idx-1] = '\n';   /* overwriting final tab */

/* Put code for writing tmpbuf to the file */  
    }
/* Close the file */
    PQfinish();
    return(0);
}

I may have overlooked something but you should get the general idea of
how to do it.

Robert

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

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: Robert.Patrick@cs.cmu.edu, Pconrad@eecis.udel.EDU
  Subject: Re: Utility for tab_separated_text
  In-Reply-To: <wjDvu9e00hPeBErV1s@cs.cmu.edu>

* 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