Re: Exporting data from PostgreSQL

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Exporting data from PostgreSQL
Date: 2003-11-01 07:28:34
Message-ID: 001CF662-0C3D-11D8-80E5-0005029FC1A7@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


On Sunday, Jun 15, 2003, at 23:03 Asia/Tokyo, brew(at)theMode(dot)com wrote:

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

Likewise catching up and cleaning out the mailboxes. I've since
implemented a similar solution using PHP to build up a string and pass
it to a user via a webpage. Works well for handing data off to people
who don't need or have access to the "database proper". Thanks for the
response!

Michael

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message MaFa 2003-11-01 15:55:33 Update cursor - current of??
Previous Message Marc G. Fournier 2003-11-01 06:16:30 Re: [OT] Unable to access PostgreSQL mailing list archive