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 the

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 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';

Re: [SQL] oracle to postgres migration question

2010-06-16 Thread Scott Marlowe
On Wed, Jun 16, 2010 at 1:42 PM, Chris Browne cbbro...@acm.org 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

[SQL] oracle to postgres migration question

2010-06-15 Thread Joshua Gooding
Hello, I'm looking for the postgres equivalent of oracles: set numwidth command. Is there an equivalent? Thanks in advance! - Josh -- Joshua Gooding Software Engineer TTi Technologies Wheeling, WV 26003 w: 304-233-5680 x 308 c: 304-794-8341 -- Sent via pgsql-sql mailing list

Re: [SQL] oracle to postgres migration question

2010-06-15 Thread Bruce Momjian
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. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB

Re: [SQL] oracle to postgres migration question

2010-06-15 Thread Scott Marlowe
On Tue, Jun 15, 2010 at 1:09 PM, Joshua Gooding jgood...@ttitech.net wrote: Hello, I'm looking for the postgres equivalent of oracles: set numwidth command.  Is there an equivalent? Psql uses dynamic formatting for such things. Not sure there's really a big need for it. Can you give an

Re: [SQL] oracle to postgres migration question

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

Re: [SQL] oracle to postgres migration question

2010-06-15 Thread Scott Marlowe
On Tue, Jun 15, 2010 at 2:19 PM, Stephen Frost sfr...@snowman.net wrote: * Bruce Momjian (br...@momjian.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

Re: [SQL] oracle to postgres migration question

2010-06-15 Thread Reinoud van Leeuwen
On Tue, Jun 15, 2010 at 04:19:15PM -0400, Stephen Frost wrote: * Bruce Momjian (br...@momjian.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

Re: [SQL] oracle to postgres migration question

2010-06-15 Thread Bruce Momjian
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

Re: [SQL] oracle to postgres migration question

2010-06-15 Thread silly sad
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,