Re: [SQL] sqlplus reporting equivalent in postgres?
-Original Message- From: Tony Capobianco [mailto:[email protected]] Sent: Thu 12/9/2010 4:47 PM To: [email protected] 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
Re: [SQL] sqlplus reporting equivalent in postgres?
On Fri, Dec 10, 2010 at 5:44 PM, Igor Neyman wrote: > > > > -Original Message- > From: Tony Capobianco > [mailto:[email protected] > ] > Sent: Thu 12/9/2010 4:47 PM > To: [email protected] > 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.
Re: [SQL] sqlplus reporting equivalent in postgres?
On Fri, Dec 10, 2010 at 7:28 PM, Gary Chambers 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?
