Re: psql -e - Mailing list pgsql-novice

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 ?

> 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!"
> > -----------------------------------------------------------------------------
>


-----------------------------------------------------------------------------
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!"
-----------------------------------------------------------------------------