Обсуждение: Postgres Tool Question

Поиск
Список
Период
Сортировка

Postgres Tool Question

От
"Samuel A. Mullen"
Дата:
Are there any tools for generating reports for Postgres?  I searched
RedHat, Enterprise Linux, the HOWTO, and haven't found anything.

Sam
--
 _____________________
/   Samuel A. Mullen  \
|  Programmer Analyst  |_______________________________________________
|  Opportunities Unl.  | Of old hast thou laid the foundation of the   \
\_____________________/| earth: and the heavens [are] the work of thy  |
                       | hands.                                        |
                       |                    Psalms 102:24              |
                       \_______________________________________________/

Re: Postgres Tool Question

От
"Brett W. McCoy"
Дата:
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


Re: Postgres Tool Question

От
"Samuel A. Mullen"
Дата:
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               |
                       \_______________________________________________/

Re: Postgres Tool Question

От
"Brett W. McCoy"
Дата:
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.


RE: Postgres Tool Question

От
"Brett W. McCoy"
Дата:
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"


Re: Postgres Tool Question

От
Webb Sprague
Дата:
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/