> -----Original Message----- > From: Robert Treat [mailto:[EMAIL PROTECTED]] > Sent: 13 January 2003 22:01 > To: Greg Copeland > Cc: Dave Page; [EMAIL PROTECTED]; PostgresSQLHackers Mailing List > Subject: Re: [HACKERS] \d type queries - why not views in > system catalog?!? > > > You have to do it in functions because some of the \ commands > use multiple queries and logic inside the C code.
pgAdmin lists far more comprehensive data the psql and does it from single queries 95% of the time. I'm sure someone more expert in SQL than me could get pretty much all the other 5% sorted... Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html