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] |
+----------------------------------------------------------------+
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. |
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 |