Is psqlodbc what I"m looking for

Is psqlodbc what I"m looking for

am 22.02.2006 23:44:13 von Dianne Yumul

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

Re: Is psqlodbc what I"m looking for

am 23.02.2006 09:07:49 von Peter Eisentraut

Dianne Yumul wrote:
> Excel has a way of querying the database but it needs an odbc driver,
> is psqlodbc this driver?

Yes

> And does it compile and work on Mac OS X (10.4.5 and 10.3.9)?

I can't say for sure, but we expect it to.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Re: Is psqlodbc what I"m looking for

am 23.02.2006 18:07:25 von Dianne Yumul

Thank you for the response. As I was researching more yesterday, I
just realized I need to install libiodbc (from iodbc.org), along with
psqlodbc on the client to get it to access the postgresql database on
the server. I got libiodbc built and installed and will be working
on building and installing psqlodbc today.

Thank you.

Dianne

On Feb 23, 2006, at 12:07 AM, Peter Eisentraut wrote:

> Dianne Yumul wrote:
>> Excel has a way of querying the database but it needs an odbc driver,
>> is psqlodbc this driver?
>
> Yes
>
>> And does it compile and work on Mac OS X (10.4.5 and 10.3.9)?
>
> I can't say for sure, but we expect it to.
>
> --
> Peter Eisentraut
> http://developer.postgresql.org/~petere/
>


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: Is psqlodbc what I"m looking for

am 23.02.2006 18:44:57 von george young

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

Re: Is psqlodbc what I"m looking for

am 23.02.2006 20:34:51 von Dianne Yumul

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


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster