DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=W9q571DgyfAH8pUOyU70YI9TYZQkoeO+57tEJKh2B1HSc5cYfppzwed8UWo5uR7OJf
	HZWVo2vlafh060yFVdcw02T0uuSj0u+rT2h9SI8OESJi4ZZM9iogH4CNnUrpHJ6k+Zh5
	5KEVHgmpVaempirUWH/ESik65to3MC9+9HLs4=
MIME-Version: 1.0
In-Reply-To: <20100615201915.GK21875@tamriel.snowman.net>
References: <4C17CFF0.5050300@ttitech.net>
	<201006151954.o5FJsxO14357@momjian.us>
	<20100615201915.GK21875@tamriel.snowman.net>
Date: Tue, 15 Jun 2010 15:14:51 -0600
Message-ID: <AANLkTil1LJ7eyThZvKUlq51FtY-WsCWuEm17MccWuZue@mail.gmail.com>
Subject: Re: oracle to postgres migration question
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Stephen Frost <sfrost@snowman.net>
Cc: Bruce Momjian <bruce@momjian.us>, Joshua Gooding <JGooding@ttitech.net>,
	pgsql-sql@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Tue, Jun 15, 2010 at 2:19 PM, Stephen Frost <sfrost@snowman.net> wrote:
> * Bruce Momjian (bruce@momjian.us) wrote:
>> Joshua Gooding wrote:
>> > Hello,
>> >
>> > I'm looking for the postgres equivalent of oracles: set numwidth
>> > command. =A0Is there an equivalent?
>>
>> If we knew what it did, we might be able to help you.
>
> Changes the display-width for numeric values. =A0SQL*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.