Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [206.210.65.6]) by hub.org (8.9.1/8.9.1) with ESMTP id LAA05755 for ; Wed, 25 Nov 1998 11:03:31 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id KAA28221; Wed, 25 Nov 1998 10:55:33 -0500 (EST) To: dbmss@yahoo.com cc: pgsql-sql@hub.org Subject: Re: Question about schema In-reply-to: Your message of Tue, 24 Nov 1998 23:00:24 -0500 (EST) <199811250400.XAA10150@hub.org> Date: Wed, 25 Nov 1998 10:55:33 -0500 Message-ID: <28219.912009333@sss.pgh.pa.us> From: Tom Lane dbmss@yahoo.com writes: > Can I use SQL to get info about a table > which can be gotten by doing a > \d [table name] > under psql? psql uses plain old SQL queries to extract the info it presents with \d; it's not doing anything you couldn't do too. Read the source code for psql (src/bin/psql/psql.c) to see what queries are used to produce the various sorts of \d reports. For example, the particular case of "\d table" is handled in the routine named tableDesc, and from looking at that you can see that it constructs a primary query like this: SELECT a.attnum, a.attname, t.typname, a.attlen, a.atttypmod, a.attnotnull, a.atthasdef FROM pg_class c, pg_attribute a, pg_type t WHERE c.relname = '' and a.attnum > 0 and a.attrelid = c.oid and a.atttypid = t.oid ORDER BY attnum Looks like there are additional queries made to get the values of field defaults and so forth. All this stuff is kept in the system tables, and you can query those tables with ordinary queries. regards, tom lane