Re: [SQL] oracle to postgres migration question
* 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 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. ehh, but we provide formatting functions and you can change the output format in psql to something more useful if you want (and there's always COPY too). tbh, I'm alot happier w/ psql than SQL*Plus in that regard. People who are trying to parse psql's output directly should realize they probably are going about it the wrong way. :) Stephen signature.asc Description: Digital signature
Re: [SQL] oracle to postgres migration question
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 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 sorry for the delay guys, and thank you for all the replies. The problem I was having, is the data in field 'track_start' was a number type in oracle. I switched it out to a real in postgres, however when I displayed the column (via psql) it was printing out for example (1.23546e12). I know you could format the output via Sql Plus but I was not sure what (if anything) you could do in postgres for that. That being said, I then re-modified the field type and it displays properly. I went from a real to a integer type and it seemed to clear up every issue I was having (both displaying and programatically) -- 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] oracle to postgres migration question
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.html MS apparently now has a team dedicated to tracking problems with Linux and publicizing them. I guess eventually they'll figure out this back fires... ;) -- William Burrow aa...@delete.fan.nb.ca -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] oracle to postgres migration question
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 at least making the output something like tab, space, pipe delimited you can parse it. On systems with only bash to play with, I've done that before because it and psql were the only tools I had to work with. I wouldn't try to write some masterpiece artwork of code around psql output, but for some short scripts it's usable, and way easier than dealing with Oracle. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
[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 (pgsql-sql@postgresql.org) 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 br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + None of us is going to be here forever. + -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) 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 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 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 (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] oracle to postgres migration question
* 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 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 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 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 (pgsql-sql@postgresql.org) 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 (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 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 Leeuwenreinou...@n.leeuwen.net http://reinoud.van.leeuwen.net kvk 27320762 __ -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) 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 br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + None of us is going to be here forever. + -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) 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 (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
