Re: [SQL] oracle to postgres migration question

2010-06-16 Thread Scott Marlowe
On Wed, Jun 16, 2010 at 1:42 PM, Chris Browne wrote: > sfr...@snowman.net (Stephen Frost) writes: >> People who are trying to parse psql's output directly should realize >> they probably are going about it the wrong way. :) > > There's a set of people I need to tell that to... If you're at least

Re: [SQL] oracle to postgres migration question

2010-06-16 Thread Chris Browne
sfr...@snowman.net (Stephen Frost) writes: > People who are trying to parse psql's output directly should realize > they probably are going about it the wrong way. :) There's a set of people I need to tell that to... -- select 'cbbrowne' || '@' || 'cbbrowne.com'; http://cbbrowne.com/info/internet

Re: [SQL] oracle to postgres migration question

2010-06-16 Thread Joshua Gooding
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

Re: [SQL] oracle to postgres migration question

2010-06-16 Thread Stephen Frost
* Bruce Momjian (br...@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 t