Re: [HACKERS] psql listTables

2004-07-23 Thread Thomas F . O'Connell
I know, but I don't get too many opportunities to contribute... :) Just figured I'd mention it. -tfo On Jul 23, 2004, at 4:06 PM, Tom Lane wrote: "Thomas F.O'Connell" <[EMAIL PROTECTED]> writes: I realize this is a trivial issue, but it seems like logic could be added to the CASE statement to preve

Re: [HACKERS] psql listTables

2004-07-23 Thread Tom Lane
"Thomas F.O'Connell" <[EMAIL PROTECTED]> writes: > I realize this is a trivial issue, but it seems like logic could be > added to the CASE statement to prevent irrelevant SELECT material from > being output. Hardly seems worth the trouble ... regards, tom lane -

[HACKERS] psql listTables

2004-07-23 Thread Thomas F . O'Connell
In examining the output of psql -E to get some templates for some queries I'm developing, I noticed in describe.c that there is logic to inform the final IN clause that gets printed for relkind but no similar logic for the CASE clause. Here's what I get from a \d in 7.4.1: SELECT n.nspname as "