Re: psql -e

Hi-

Yes-I had already tried that....that is when I was given a list of what was all
possible switches were and hence why I tried -e.

psql: illegal option -- E
Usage: psql [options] [dbname]
-a authsvc set authentication service
-A turn off alignment when printing out attributes

-c query run single query (slash commands too)
-d dbName specify database name
-e echo the query sent to the backend
-f filename use file as a source of queries
-F sep set the field separator (default is '|')
[cut]

Any other thoughts?

Thanks-
Beth

"D. Duccini" wrote:

> see if you can start it with a capitalized -E
>
> actmgr=> \dt
> QUERY: SELECT usename, relname, relkind, relhasrules FROM pg_class,
> pg_user WHERE usesysid = relowner and ( relkind = 'r') and relname !~
> '^pg_' ORDER BY relname
>
> On Wed, 1 Nov 2000, Beth Gatewood wrote:
>
> >
> > Hi -
> >
> > There has been suggestions to start psql with the -E switch to see the
> > queries that the \ commands exectue.
> >
> > However,
> >
> > 1-I can not use this option...we are currently running 6.3 version and I
> > only see a -e switch
> >
> > 2- If I use the -e switch, if I type a query by hand I will get the
> > query echoed back (QUERY:blah blah blah). However, if I execute \dt I
> > do not see any query echoed.
> >
> > Thanks for your thoughts on this...
> > Beth
> >
>
> -----------------------------------------------------------------------------
> david(at)backpack(dot)com BackPack Software, Inc. www.backpack.com
> +1 651.645.7550 voice "Life is an Adventure.
> +1 651.645.9798 fax Don't forget your BackPack!"
> -----------------------------------------------------------------------------