From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
---|---|
To: | The Hermit Hacker <scrappy(at)hub(dot)org> |
Cc: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>, hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] vacuum updated... |
Date: | 1999-03-30 03:57:41 |
Message-ID: | 199903300357.MAA05685@srapc451.sra.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>> 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?":-)
./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
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 1999-03-30 04:07:12 | Re: [HACKERS] vacuum updated... |
Previous Message | Clark Evans | 1999-03-30 02:43:00 | SELECT (CASE ... ) gives copyObject error in current CVS build. |