Re: oracle to postgres migration question

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

On Tue, Jun 15, 2010 at 2:19 PM, Stephen Frost <sfrost(at)snowman(dot)net> wrote:
> * Bruce Momjian (bruce(at)momjian(dot)us) wrote:
>> Joshua Gooding wrote:
>> > Hello,
>> >
>> > I'm looking for the postgres equivalent of oracles: set numwidth
>> > command.  Is there an equivalent?
>>
>> If we knew what it did, we might be able to help you.
>
> Changes the display-width for numeric values.  SQL*Plus will then
> right-justify the number based on the numwidth value.

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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2010-06-15 22:45:04 Re: oracle to postgres migration question
Previous Message Reinoud van Leeuwen 2010-06-15 21:10:58 Re: oracle to postgres migration question