Re: psql -e

From: "D(dot) Duccini" <duccini(at)backpack(dot)com>
To: Beth Gatewood <bethg(at)mbt(dot)washington(dot)edu>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: psql -e
Date: 2000-11-02 03:58:47
Message-ID: Pine.GSO.4.03.10011012157390.16020-100000@ra.bpsi.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


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

In response to

  • psql -e at 2000-11-02 00:38:04 from Beth Gatewood

Responses

  • Re: psql -e at 2000-11-02 17:34:16 from Beth Gatewood

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2000-11-02 08:33:10 Re: [NOVICE] Array Problem
Previous Message Beth Gatewood 2000-11-02 00:38:04 psql -e