Re: [SQL] sqlplus reporting equivalent in postgres?

2010-12-11 Thread Thomas Kellerer

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




--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql


Re: [SQL] sqlplus reporting equivalent in postgres?

2010-12-11 Thread Gary Chambers

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

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql


Re: [SQL] sqlplus reporting equivalent in postgres?

2010-12-10 Thread Samuel Gendler
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?


Re: [SQL] sqlplus reporting equivalent in postgres?

2010-12-10 Thread Samuel Gendler
On Fri, Dec 10, 2010 at 5:44 PM, Igor Neyman  wrote:

>
>
>
> -Original Message-
> From: Tony Capobianco 
> [mailto:tcapobia...@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.


Re: [SQL] sqlplus reporting equivalent in postgres?

2010-12-10 Thread Igor Neyman



-Original Message-
From: Tony Capobianco [mailto:tcapobia...@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


[SQL] sqlplus reporting equivalent in postgres?

2010-12-09 Thread Tony Capobianco
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


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql