Postgres Tool Question

On Tue, 9 May 2000, Samuel A. Mullen wrote:

Are there any tools for generating reports for Postgres? I searched
RedHat, Enterprise Linux, the HOWTO, and haven't found anything.

http://www.perl.com :-)

I think pgAccess has some report printing faciliites as well. You can
always connect to PostgreSQL via MS-Access and generate reports out of
that also.

Brett W. McCoy
http://www.chapelperilous.net
---------------------------------------------------------------------------
If the very old will remember, the very young will listen.
-- Chief Dan George

I know I can use perl. I already do, but sometimes you want your
reports to look a little cleaner than just plain old text. I know I
could probably throw in some LaTeX or Groff, but I kinda wanted
something a bit more user-friendly, I would also like something to
develop complex reports.

As far as that little MS Access comment goes. It took me a long time to
find a job where I just use Linux, I don't want to regress to Windows.
:)

Sam

"Brett W. McCoy" wrote:

On Tue, 9 May 2000, Samuel A. Mullen wrote:

Are there any tools for generating reports for Postgres? I searched
RedHat, Enterprise Linux, the HOWTO, and haven't found anything.

http://www.perl.com :-)

I think pgAccess has some report printing faciliites as well. You can
always connect to PostgreSQL via MS-Access and generate reports out of
that also.

Brett W. McCoy
http://www.chapelperilous.net
---------------------------------------------------------------------------
If the very old will remember, the very young will listen.
-- Chief Dan George

--
_____________________
/ Samuel A. Mullen \
| Programmer Analyst |_______________________________________________
| Opportunities Unl. | Great deliverance giveth he to his king; and \
\_____________________/| showeth mercy to his anointed, to David, and |
| to his seed for evermore. |
| Psalms 18:49 |
\_______________________________________________/

On Tue, 9 May 2000, Samuel A. Mullen wrote:

I know I can use perl. I already do, but sometimes you want your
reports to look a little cleaner than just plain old text. I know I
could probably throw in some LaTeX or Groff, but I kinda wanted
something a bit more user-friendly, I would also like something to
develop complex reports.

I think the latest version of Applix has ODBC drivers for PostgreSQL. I'm
sure you could generate some nice looking reports out of that.

Brett W. McCoy
http://www.chapelperilous.net
---------------------------------------------------------------------------
Intolerance is the last defense of the insecure.

On Tue, 9 May 2000, Chris Carbaugh wrote:

Have you considered HTML reports?
How about PDF?

I'm not sure if PERL has a PDF interface, but I know PHP does.

PHP _is_ a hypertext preprocessor, but you can run it from the shell (or a
script) as a stand alone executable. I'm sure you could compile a PDF that
way.

Yes, Perl has PDF module, available from CPAN.

Brett W. McCoy
http://www.chapelperilous.net
---------------------------------------------------------------------------
Cheese -- milk's leap toward immortality.
-- Clifton Fadiman, "Any Number Can Play"

a2ps is a great program for making plain old text look
decent. I think it will also accept latex or
postscript, which you could embed with Perl. Search
"a2ps" on freshmeat.net.

--- "Samuel A. Mullen" <smullen@oppunl.com> wrote:

I know I can use perl. I already do, but sometimes
you want your
reports to look a little cleaner than just plain old
text. I know I
could probably throw in some LaTeX or Groff, but I
kinda wanted
something a bit more user-friendly, I would also
like something to
develop complex reports.

As far as that little MS Access comment goes. It
took me a long time to
find a job where I just use Linux, I don't want to
regress to Windows.
:)

Sam

"Brett W. McCoy" wrote:

On Tue, 9 May 2000, Samuel A. Mullen wrote:

Are there any tools for generating reports for

Postgres? I searched

RedHat, Enterprise Linux, the HOWTO, and haven't

found anything.

http://www.perl.com :-)

I think pgAccess has some report printing

faciliites as well. You can

always connect to PostgreSQL via MS-Access and

generate reports out of

that also.

Brett W. McCoy

http://www.chapelperilous.net

---------------------------------------------------------------------------

If the very old will remember, the very young will

listen.

-- Chief Dan George

--
_____________________
/ Samuel A. Mullen \
| Programmer Analyst
|_______________________________________________
| Opportunities Unl. | Great deliverance giveth he
to his king; and \
\_____________________/| showeth mercy to his
anointed, to David, and |
| to his seed for evermore.
|
| Psalms
18:49 |
\_______________________________________________/

__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/