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.
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 |