Re: oracle to postgres migration question

On 6/16/2010 1:02 AM, silly sad wrote:
> On 06/16/10 02:45, Bruce Momjian 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.
>
> count me in :-)
>
> i even suspect this exactly is a Secret of the oracle Power.
> "higher performance through lower level of control"
>
>
sorry for the delay guys, and thank you for all the replies.

The problem I was having, is the data in field 'track_start' was a
number type in oracle. I switched it out to a real in postgres, however
when I displayed the column (via psql) it was printing out for example
(1.23546e12). I know you could format the output via Sql Plus but I was
not sure what (if anything) you could do in postgres for that. That
being said, I then re-modified the field type and it displays properly.
I went from a real to a integer type and it seemed to clear up every
issue I was having (both displaying and programatically)

--
Joshua Gooding
Software Engineer
TTi Technologies Wheeling, WV 26003

w: 304-233-5680 x 308
c: 304-794-8341