Re: oracle to postgres migration question

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Joshua Gooding <JGooding(at)ttitech(dot)net>, pgsql-sql(at)postgresql(dot)org
Subject: Re: oracle to postgres migration question
Date: 2010-06-16 12:28:10
Message-ID: 20100616122810.GM21875@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

* Bruce Momjian (bruce(at)momjian(dot)us) wrote:
> Scott Marlowe wrote:
> > Note that psql automagically right justifies numerics and dynamically
> > sizes all columns so you don't have to do as much of this stuff.
> > Oracle always made me feel like I was operating the machine behind the
> > curtain in the Wizard of Oz, lots of handles and switches and knobs I
> > had to mess with to get useful output.
>
> Yeah, I have heard that description many times in other forms.

ehh, but we provide formatting functions and you can change the output
format in psql to something more useful if you want (and there's always
COPY too). tbh, I'm alot happier w/ psql than SQL*Plus in that regard.
People who are trying to parse psql's output directly should realize
they probably are going about it the wrong way. :)

Stephen

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Chris Browne 2010-06-16 19:42:40 Re: oracle to postgres migration question
Previous Message Joshua Gooding 2010-06-16 11:50:34 Re: oracle to postgres migration question