pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedsqlplus reporting equivalent in postgres?
6+ messages / 5 participants
[nested] [flat]
* sqlplus reporting equivalent in postgres?
@ 2010-12-09 21:47 Tony Capobianco <tcapobianco@prospectiv.com>
2010-12-11 01:44 ` Re: sqlplus reporting equivalent in postgres? Igor Neyman <ineyman@perceptron.com>
0 siblings, 1 reply; 6+ messages in thread
From: Tony Capobianco @ 2010-12-09 21:47 UTC (permalink / raw)
To: pgsql-sql
We're in the process of porting our Oracle 10.2 datawarehouse over to
PostGres 8.4. One thing we rely upon are daily/hourly reports that are
run and formatted in sqlplus (break on report, compute sum, etc.). Is
there an equivalent available in postgres?
Thanks.
Tony
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: sqlplus reporting equivalent in postgres?
2010-12-09 21:47 sqlplus reporting equivalent in postgres? Tony Capobianco <tcapobianco@prospectiv.com>
@ 2010-12-11 01:44 ` Igor Neyman <ineyman@perceptron.com>
2010-12-11 03:23 ` Re: sqlplus reporting equivalent in postgres? Samuel Gendler <sgendler@ideasculptor.com>
0 siblings, 1 reply; 6+ messages in thread
From: Igor Neyman @ 2010-12-11 01:44 UTC (permalink / raw)
To: Tony Capobianco <tcapobianco@prospectiv.com>; pgsql-sql
-----Original Message-----
From: Tony Capobianco [mailto:tcapobianco@prospectiv.com]
Sent: Thu 12/9/2010 4:47 PM
To: pgsql-sql@postgresql.org
Subject: sqlplus reporting equivalent in postgres?
We're in the process of porting our Oracle 10.2 datawarehouse over to
PostGres 8.4. One thing we rely upon are daily/hourly reports that are
run and formatted in sqlplus (break on report, compute sum, etc.). Is
there an equivalent available in postgres?
Thanks.
Tony
psql - not as advanced, doesn't have all the features SQL*Plus has.
Igor Neyman
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: sqlplus reporting equivalent in postgres?
2010-12-09 21:47 sqlplus reporting equivalent in postgres? Tony Capobianco <tcapobianco@prospectiv.com>
2010-12-11 01:44 ` Re: sqlplus reporting equivalent in postgres? Igor Neyman <ineyman@perceptron.com>
@ 2010-12-11 03:23 ` Samuel Gendler <sgendler@ideasculptor.com>
2010-12-11 03:28 ` Re: sqlplus reporting equivalent in postgres? Gary Chambers <gwc@gwcmail.com>
2010-12-11 10:50 ` Re: sqlplus reporting equivalent in postgres? Thomas Kellerer <spam_eater@gmx.net>
0 siblings, 2 replies; 6+ messages in thread
From: Samuel Gendler @ 2010-12-11 03:23 UTC (permalink / raw)
To: Igor Neyman <ineyman@perceptron.com>; +Cc: Tony Capobianco <tcapobianco@prospectiv.com>; pgsql-sql
On Fri, Dec 10, 2010 at 5:44 PM, Igor Neyman <ineyman@perceptron.com> wrote:
>
>
>
> -----Original Message-----
> From: Tony Capobianco [mailto:tcapobianco@prospectiv.com<tcapobianco@prospectiv.com>
> ]
> Sent: Thu 12/9/2010 4:47 PM
> To: pgsql-sql@postgresql.org
> Subject: sqlplus reporting equivalent in postgres?
>
> We're in the process of porting our Oracle 10.2 datawarehouse over to
> PostGres 8.4. One thing we rely upon are daily/hourly reports that are
> run and formatted in sqlplus (break on report, compute sum, etc.). Is
> there an equivalent available in postgres?
>
> Thanks.
> Tony
>
> psql - not as advanced, doesn't have all the features SQL*Plus has.
>
>
On the other hand, it is at least capable of command history and readline
support.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: sqlplus reporting equivalent in postgres?
2010-12-09 21:47 sqlplus reporting equivalent in postgres? Tony Capobianco <tcapobianco@prospectiv.com>
2010-12-11 01:44 ` Re: sqlplus reporting equivalent in postgres? Igor Neyman <ineyman@perceptron.com>
2010-12-11 03:23 ` Re: sqlplus reporting equivalent in postgres? Samuel Gendler <sgendler@ideasculptor.com>
@ 2010-12-11 03:28 ` Gary Chambers <gwc@gwcmail.com>
2010-12-11 03:44 ` Re: sqlplus reporting equivalent in postgres? Samuel Gendler <sgendler@ideasculptor.com>
1 sibling, 1 reply; 6+ messages in thread
From: Gary Chambers @ 2010-12-11 03:28 UTC (permalink / raw)
To: Samuel Gendler <sgendler@ideasculptor.com>; +Cc: Igor Neyman <ineyman@perceptron.com>; Tony Capobianco <tcapobianco@prospectiv.com>; pgsql-sql
>> psql - not as advanced, doesn't have all the features SQL*Plus has.
> On the other hand, it is at least capable of command history and readline
> support.
Yes, but rlwrap will eliminate that limitation.
-- Gary Chambers
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: sqlplus reporting equivalent in postgres?
2010-12-09 21:47 sqlplus reporting equivalent in postgres? Tony Capobianco <tcapobianco@prospectiv.com>
2010-12-11 01:44 ` Re: sqlplus reporting equivalent in postgres? Igor Neyman <ineyman@perceptron.com>
2010-12-11 03:23 ` Re: sqlplus reporting equivalent in postgres? Samuel Gendler <sgendler@ideasculptor.com>
2010-12-11 03:28 ` Re: sqlplus reporting equivalent in postgres? Gary Chambers <gwc@gwcmail.com>
@ 2010-12-11 03:44 ` Samuel Gendler <sgendler@ideasculptor.com>
0 siblings, 0 replies; 6+ messages in thread
From: Samuel Gendler @ 2010-12-11 03:44 UTC (permalink / raw)
To: Gary Chambers <gwc@gwcmail.com>; +Cc: Igor Neyman <ineyman@perceptron.com>; Tony Capobianco <tcapobianco@prospectiv.com>; pgsql-sql
On Fri, Dec 10, 2010 at 7:28 PM, Gary Chambers <gwc@gwcmail.com> wrote:
> psql - not as advanced, doesn't have all the features SQL*Plus has.
>>>
>> On the other hand, it is at least capable of command history and readline
>> support.
>>
>
> Yes, but rlwrap will eliminate that limitation.
>
>
Damn! Why didn't anyone tell me about that a couple of years ago when I had
to deal with Oracle?
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: sqlplus reporting equivalent in postgres?
2010-12-09 21:47 sqlplus reporting equivalent in postgres? Tony Capobianco <tcapobianco@prospectiv.com>
2010-12-11 01:44 ` Re: sqlplus reporting equivalent in postgres? Igor Neyman <ineyman@perceptron.com>
2010-12-11 03:23 ` Re: sqlplus reporting equivalent in postgres? Samuel Gendler <sgendler@ideasculptor.com>
@ 2010-12-11 10:50 ` Thomas Kellerer <spam_eater@gmx.net>
1 sibling, 0 replies; 6+ messages in thread
From: Thomas Kellerer @ 2010-12-11 10:50 UTC (permalink / raw)
To: pgsql-sql
Samuel Gendler wrote on 11.12.2010 04:23:
> psql - not as advanced, doesn't have all the features SQL*Plus has.
>
>
> On the other hand, it is at least capable of command history and readline support.
Hmm, for me SQL*Plus does support command history, but this is getting off-topic now...
Regards
Thomas
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2010-12-11 10:50 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-12-09 21:47 sqlplus reporting equivalent in postgres? Tony Capobianco <tcapobianco@prospectiv.com>
2010-12-11 01:44 ` Igor Neyman <ineyman@perceptron.com>
2010-12-11 03:23 ` Samuel Gendler <sgendler@ideasculptor.com>
2010-12-11 03:28 ` Gary Chambers <gwc@gwcmail.com>
2010-12-11 03:44 ` Samuel Gendler <sgendler@ideasculptor.com>
2010-12-11 10:50 ` Thomas Kellerer <spam_eater@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox