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

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

[SQL] Oracle to Postgres

2004-11-07 Thread Mickael Faivre-Macon
Hi, I have this Pro*C statement EXEC SQL AT db_name DESCRIBE BIND VARIABLES FOR S1 INTO bdp; that I must translate into PL/pgSQL (compiled into c with ecpg) I can not find a description of describe in the postgres 7.3 documentation. Could someone help me ? Postgres does not support SQLDA structu