Re: [GENERAL] translate "bug"?

From: Stuart Rison <stuart(at)NOJUNK_ludwig(dot)ucl(dot)ac(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] translate "bug"?
Date: 1998-07-08 11:36:56
Message-ID: l0311071cb1c902d8c5d9@[128.40.242.190]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Yeah, I've rethough about it and it does seem a bit out-there ;) ... I'm
sure there was one time where I encountered a situation where you would
want to use the \d? commands in an SQL statement environment but I can't
even begin to remember... so maybe it wasn't that important afterall and
regex'ing will do just fine.

I do feel though that the \df <regex> functionality would be useful in
other catalog queries (thank james, I didn't know that what they were
called) e.g. \do <regex> or \dt <regex> (which would get you all tables
containing <regex> e.g. titles, tileauthors, titleditors etc, as opposed to
\d titles which would get you just table titles).

or am I being dim again? [that dreaded feeling of posting something really
stupid...]

Cheers,

S.

>> >I realize you want it inside the psql program, but the above should get the
>> >same results pretty quick...james
>>
>> Thanks for that James... I've been trying to work out how to do it for ages!
>
>I will look into implementing \df kjasdf, and do it as a regex!

>
>>
>> I have to agree with Richard though, it would be very nice to have it
>> within psql. Furthermore, it would be great if such functionality
>> could be extended to all \d? queries. In fact, and I'm sure there actually
>> is a way to this if you're more knowledgeable than I, since most of these
>> \d? queries basically yield a 'SQL' table, wouldn't be nice to be able to
>> perform SQL on the (e.g. select * from \df where function = 'int2_text';
>> etc.)
>>
>> Or am I just getting carried away! 8)
>
>That is a little strange.
>

+-------------------------+--------------------------------------+
| Stuart Rison | Ludwig Institute for Cancer Research |
+-------------------------+ University College London |
| Tel. (0171) 878 4041 | 91 Riding House Street |
| Fax. (0171) 878 4040 | London, W1P 8BT, UNITED KINGDOM. |
+-------------------------+--------------------------------------+
| stuart(at)NOJUNK_ludwig(dot)ucl(dot)ac(dot)uk [Remove NOJUNK_ for it to work] |
+----------------------------------------------------------------+

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Piotr Podstawski 1998-07-08 12:24:21 ver 6.0
Previous Message Stuart Rison 1998-07-08 11:36:03 Re: [GENERAL] nodeRead ERROR.

Browse pgsql-hackers by date

  From Date Subject
Next Message Herouth Maoz 1998-07-08 12:27:15 Re: [GENERAL] translate "bug"?
Previous Message Dr. Michael Meskes 1998-07-08 08:36:12 Re: [HACKERS] PostgreSQL Backend as SW Gateway to Oracle