Thanks for the information. I was not aware of tablefunc, I will look
into it before building psqlodbc. If it will do what we need then it
can save me a lot of time.
Dianne
On Feb 23, 2006, at 9:44 AM, george young wrote:
> Just a thought. Have you looked at the crosstab functions in the
> contrib/tablefunc source directory? I understand that some people use
> this for creating pivot tables. If it can do what you need, perhaps
> you can completely avoid exporting into excel.
>
> -- George Young
>
> On Wed, 22 Feb 2006 14:44:13 -0800
> Dianne Yumul <dianne@wellsgaming.com> threw this fish to the penguins:
>
>> Hello to all,
>>
>> We have Postgresql 8.0.6 on a Linux (Fedora Core 4) server. We need
>> to create pivot tables (for auditing purposes) on the data we have
>> stored on the database on this server. For a while now I've been
>> running queries, dumping results on text files and importing them to
>> Excel. But sometimes the data does not fit on one sheet.
>>
>> Excel has a way of querying the database but it needs an odbc driver,
>> is psqlodbc this driver? And does it compile and work on Mac OS X
>> (10.4.5 and 10.3.9)?
>>
>> Any help would be greatly appreciated.
>>
>> Thank you,
>>
>> Dianne
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 4: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>>
>
>
> --
> "Are the gods not just?" "Oh no, child.
> What would become of us if they were?" (CSL)
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that
> your
> message can get through to the mailing list cleanly
>