Re: psql -e

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: "D. Duccini" <duccini@backpack.com>
Cc: Beth Gatewood <bethg@mbt.washington.edu>, pgsql-novice@postgresql.org
Date: 2000-11-02T17:59:17Z
Lists: pgsql-novice
"D. Duccini" <duccini@backpack.com> writes:
> other suggestions:

> 1. upgrade :P
> 2. try getting a newer version of just psql ?
> 3. have someone else run the queries and give you the output ?

Or

4. Run postmaster with -d2 and look in postmaster log to see what
   psql is doing.
5. Read the psql source code to see what queries it will emit.

Suggestions 2 & 3 might not work so well, since the system catalogs
tend to change somewhat from release to release, and psql's queries
get adjusted appropriately.  A query generated by a several-versions-
newer psql might not work as desired on Beth's 6.3 installation.

I like suggestion #1 myself ;-).  6.3 is roughly late Neolithic in
Postgres years...

			regards, tom lane