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@backpack.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!"
> -----------------------------------------------------------------------------