From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
---|---|
To: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
Cc: | hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] vacuum updated... |
Date: | 1999-03-30 04:07:12 |
Message-ID: | Pine.BSF.4.05.9903300006450.47558-100000@thelab.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
From | Date | Subject | |
---|---|---|---|
Next Message | Jackson, DeJuan | 1999-03-30 04:07:20 | RE: [SQL] indexing a datetime by date |
Previous Message | Tatsuo Ishii | 1999-03-30 03:57:41 | Re: [HACKERS] vacuum updated... |