Re: Exporting data from PostgreSQL

From: brew(at)theMode(dot)com
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Exporting data from PostgreSQL
Date: 2003-06-15 14:03:33
Message-ID: Pine.BSF.4.44.0306150959190.8736-100000@themode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


Michael....

Just going through some old email, so maybe you're way beyond needing a
response now, but:

> just to get some data out, but maybe that's what I should do.
> PHP (or other language): Make a script that'll do this for me. Can be
> used with query results.
>
> I'm probably missing something. I'd love to hear any ideas, including
> finding out if I'm just too lazy to use the two I've already thought
> of! :)

You could query and build up a string variable in php (using heredoc to
format the results as you want) then use the php mail() function to send
it out via email.

Not the most elegant, but it's one way.

brew

==========================================================================
Strange Brew (brew(at)theMode(dot)com)
Check out my Musician's Online Database Exchange (The MODE Pages)
http://www.TheMode.com
==========================================================================

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Smitha V. Babu 2003-06-16 04:22:37 PGAccess failing....
Previous Message Tom Lane 2003-06-14 17:27:28 Re: SQL INSERT Statement -- Multi-Row Insert