Re: [GENERAL] translate "bug"?

Thanks for that James... I've been trying to work out how to do it for ages!

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)

You know, I think there might be a way to do that, because I believe in some SQL
Databases, you can actually do queries against the catalogs; perhaps you can do
that with Postgress. I don't know for sure though...james

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.

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

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@NOJUNK_ludwig.ucl.ac.uk [Remove NOJUNK_ for it to work] |
+----------------------------------------------------------------+

At 14:36 +0300 on 8/7/98, Stuart Rison wrote:

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).

In my (humble?) opinion, instead of having this as a specialized command in
psql, there should rather have been a read-only view in the system which
would make it possible to look at only part of the information.

This would make the information readily available from other interfaces
beside psql, and will not force the interface developers to rely on "inside
information" telling them which tables to query and what the internal oids
are to look for. Thus, if internal things like that are changed, the view
would stay alive and easily accessible.

So, instead of \d we would have something like SELECT * from SYSRELS_VIEW.
And instead of \dt, SELECT * from SYSRELS_VIEW WHERE relation_type =
'table' (which would imply that the view will have this in ascii, where the
internal table has it in some coding). Instead of \d my_table, we'll have
SELECT * from SYSCOLS_VIEW WHERE relation = 'my_table';

I think that's more or less how it's done in Oracle and the like, isn't it?
And it relies only on something we all know - SQL queries.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma

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

I think these are good ideas. I will implement them for 6.4. Glad you
are using the new features.

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)