Thread: 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
<br /><br /><br /><p><font size="2">-----Original Message-----<br /> From: Tony Capobianco [<a href="mailto:tcapobianco@prospectiv.com">mailto:tcapobianco@prospectiv.com</a>]<br/> Sent: Thu 12/9/2010 4:47 PM<br /> To:pgsql-sql@postgresql.org<br /> Subject: sqlplus reporting equivalent in postgres?<br /><br /> We're in the process ofporting our Oracle 10.2 datawarehouse over to<br /> PostGres 8.4. One thing we rely upon are daily/hourly reports thatare<br /> run and formatted in sqlplus (break on report, compute sum, etc.). Is<br /> there an equivalent availablein postgres?<br /><br /> Thanks.<br /> Tony<br /><br /> psql - not as advanced, doesn't have all the features SQL*Plushas.<br /><br /> Igor Neyman<br /></font>
On Fri, Dec 10, 2010 at 5:44 PM, Igor Neyman <ineyman@perceptron.com> wrote:
-----Original Message-----psql - not as advanced, doesn't have all the features SQL*Plus has.
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
On the other hand, it is at least capable of command history and readline support.
On Fri, Dec 10, 2010 at 7:28 PM, Gary Chambers <gwc@gwcmail.com> wrote:
Yes, but rlwrap will eliminate that limitation.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.
Damn! Why didn't anyone tell me about that a couple of years ago when I had to deal with Oracle?
>> 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
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