Re: [HACKERS] vacuum updated... - Mailing list pgsql-hackers

From The Hermit Hacker
Subject Re: [HACKERS] vacuum updated...
Date
Msg-id Pine.BSF.4.05.9903300006450.47558-100000@thelab.hub.org
Whole thread Raw
In response to Re: [HACKERS] vacuum updated...  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-hackers
On Tue, 30 Mar 1999, Tatsuo Ishii wrote:

> >> I have some patches contributed by a user corresponding to one of our
> >> TODO list:
> >> 
> >> * Add version number in startup banners for psql and postmaster
> >> 
> >> (actually the patches only add banners to psql, not to postmaster)
> >> 
> >> Also these include tiny  fixes to psql. Do I have any chance to apply
> >> them for 6.5beta?
> >
> >How will this affect user scripts that use psql? 
> 
> Nothing except new option "-E" which shows actual queries issued by
> some \ commands (Example session follows). Sorry, I forgot to mention
> about it. I believe this will greatly reduce beginners questions: "How
> can I list tables in my database?":-)

Sounds and looks reasonable...as it doesn't affect the backend at all,
please go for it :)


> 
> ./psql -E regression Welcome to the POSTGRESQL interactive sql
> monitor:
>   Please read the file COPYRIGHT for copyright terms of POSTGRESQL
> [PostgreSQL 6.5.0 on i386-unknown-freebsd2.2.6, compiled by gcc 2.7.2.]
> 
>    type \? for help on slash commands
>    type \q to quit
>    type \g or terminate with semicolon to execute query
>  You are currently connected to the database: regression
> 
> regression=> \d
> QUERY: SELECT usename, relname, relkind, relhasrules FROM pg_class, pg_user WHERE ( relkind = 'r' OR relkind = 'i' OR
relkind= 'S')   and relname !~ '^pg_' and usesysid = relowner ORDER BY relname 
 
> 
> Database    = regression
>  +------------------+----------------------------------+----------+
>  |  Owner           |             Relation             |   Type   |
>  +------------------+----------------------------------+----------+
>  | t-ishii          | a_star                           | table    |
>  | t-ishii          | abstime_tbl                      | table    |
> [snip]
> 
> 
> --
> Tatsuo Ishii
> 

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 



pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: [HACKERS] vacuum updated...
Next
From: "Jackson, DeJuan"
Date:
Subject: RE: [SQL] indexing a datetime by date