Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 6C3746383D7 for ; Wed, 16 Jun 2010 15:27:52 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 43531-01-10 for ; Wed, 16 Jun 2010 18:27:45 +0000 (UTC) Received: from mx3.hub.org (mx3.hub.org [206.223.169.73]) by mail.postgresql.org (Postfix) with ESMTP id 9D5CC634DC7 for ; Wed, 16 Jun 2010 14:08:10 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from tamriel.snowman.net (tamriel.snowman.net [72.66.115.51]) by mx3.hub.org (Postfix) with ESMTP id 3C59E37D217 for ; Wed, 16 Jun 2010 14:08:10 -0300 (ADT) Received: by tamriel.snowman.net (Postfix, from userid 1000) id D0AC122205; Wed, 16 Jun 2010 08:28:10 -0400 (EDT) Date: Wed, 16 Jun 2010 08:28:10 -0400 From: Stephen Frost To: Bruce Momjian Cc: Scott Marlowe , Joshua Gooding , pgsql-sql@postgresql.org Subject: Re: oracle to postgres migration question Message-ID: <20100616122810.GM21875@tamriel.snowman.net> References: <201006152245.o5FMj4t10356@momjian.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="/xY1SOPLXiqzzkpe" Content-Disposition: inline In-Reply-To: <201006152245.o5FMj4t10356@momjian.us> X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/2.6.26-1-amd64 (x86_64) X-Uptime: 08:26:47 up 292 days, 23:51, 28 users, load average: 0.37, 0.26, 0.19 User-Agent: Mutt/1.5.18 (2008-05-17) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.092 tagged_above=-5 required=5 tests=BAYES_05=-0.5, DATE_IN_PAST_03_06=1.592, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: * X-Archive-Number: 201006/58 X-Sequence-Number: 34249 --/xY1SOPLXiqzzkpe Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * Bruce Momjian (bruce@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. >=20 > 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 --/xY1SOPLXiqzzkpe Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkwYw1oACgkQrzgMPqB3kigvuwCcDsl3exH+Jl+Fo8bJp09yh6Gg JlYAoJFDWpgBUhJjJ19FlvaUHOfI3bOd =XLZU -----END PGP SIGNATURE----- --/xY1SOPLXiqzzkpe--