From: Stephen Frost <sfrost@snowman.net>
To: Bruce Momjian <bruce@momjian.us>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Joshua Gooding <JGooding@ttitech.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: oracle to postgres migration question
Date: Wed, 16 Jun 2010 08:28:10 -0400
Message-ID: <20100616122810.GM21875@tamriel.snowman.net> (raw)
In-Reply-To: <201006152245.o5FMj4t10356@momjian.us>
References: <AANLkTil1LJ7eyThZvKUlq51FtY-WsCWuEm17MccWuZue@mail.gmail.com>
<201006152245.o5FMj4t10356@momjian.us>
* Bruce Momjian (bruce@momjian.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
Attachments:
signature.asc (application/pgp-signature, 196B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sfrost@snowman.net, bruce@momjian.us, scott.marlowe@gmail.com, JGooding@ttitech.net
Subject: Re: oracle to postgres migration question
In-Reply-To: <20100616122810.GM21875@tamriel.snowman.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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