Thread: Is psqlodbc what I'm looking for
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
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/
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/ >
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)
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 >