Re: psql -e - Mailing list pgsql-novice

From Tom Lane
Subject Re: psql -e
Date
Msg-id 26057.973187957@sss.pgh.pa.us
Whole thread Raw
In response to Re: psql -e  ("D. Duccini" <duccini@backpack.com>)
List 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

pgsql-novice by date:

Previous
From: "D. Duccini"
Date:
Subject: Re: psql -e
Next
From: "Mike Hammonds"
Date:
Subject: PgSQL question