[SQL] oracle to postgres migration question
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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] oracle to postgres migration question
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://enterprisedb.com + None of us is going to be here forever. + -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] oracle to postgres migration question
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're trying to accomplish? (and as Bruce mentioned, you'd get more bites if you gave a reference like http://www.oracle.com/technology/support/tech/sql_plus/htdocs/sub_var4.html#4_1_6 so people would know what you're asking for.) -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] oracle to postgres migration question
* Joshua Gooding ([email protected]) 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, Stephen signature.asc Description: Digital signature
Re: [SQL] oracle to postgres migration question
* Bruce Momjian ([email protected]) 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 will then right-justify the number based on the numwidth value. Stephen signature.asc Description: Digital signature
Re: [SQL] oracle to postgres migration question
On Tue, Jun 15, 2010 at 2:19 PM, Stephen Frost wrote: > * Bruce Momjian ([email protected]) 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 will then > right-justify the number based on the numwidth value. 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. -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] oracle to postgres migration question
On Tue, Jun 15, 2010 at 04:19:15PM -0400, Stephen Frost wrote: > * Bruce Momjian ([email protected]) 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 will then > right-justify the number based on the numwidth value. Are you migrating the server or the client? This sounds like a client issue to me.. Reinoud -- __ "Nothing is as subjective as reality" Reinoud van [email protected] http://reinoud.van.leeuwen.net kvk 27320762 __ -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] oracle to postgres migration question
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. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + None of us is going to be here forever. + -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] oracle to postgres migration question
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" -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
