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,

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 kn

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, w

Re: [SQL] oracle to postgres migration question

2010-06-15 Thread Scott Marlowe
On Tue, Jun 15, 2010 at 2:19 PM, 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 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. SQ

Re: [SQL] oracle to postgres migration question

2010-06-15 Thread Stephen Frost
* Joshua Gooding (jgood...@ttitech.net) wrote: > I'm looking for the postgres equivalent of oracles: set numwidth > command. Is there an equivalent? Nothing really equivalent, I don't believe.. You would need to wrap the column(s) you care about using to_char(). Thanks,

Re: [SQL] oracle to postgres migration question

2010-06-15 Thread Scott Marlowe
On Tue, Jun 15, 2010 at 1:09 PM, Joshua Gooding 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 example of what you'r

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 http://momjian.us EnterpriseDB http://enterpri

[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 (pgsql-sql@p