Received: from web111.yahoomail.com (web111.yahoomail.com [205.180.60.81]) by hub.org (8.10.1/8.10.1) with SMTP id e8F8lNs23989 for ; Fri, 15 Sep 2000 04:47:23 -0400 (EDT) Received: (qmail 12455 invoked by uid 60001); 15 Sep 2000 08:47:22 -0000 Message-ID: <20000915084722.12454.qmail@web111.yahoomail.com> Received: from [63.89.100.2] by web111.yahoomail.com; Fri, 15 Sep 2000 01:47:22 PDT Date: Fri, 15 Sep 2000 01:47:22 -0700 (PDT) From: Michael Teter Subject: get table schema in psql? To: pgsql-sql@hub.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200009/109 how can I get the schema of a table in psql? in oracle I would do "desc tablename". I remember sql server and ingres having a similar facility. right now the only way I seem to be able to get the information is by using pgaccess. I realize the definition of the table is probably spread across the various pg_ system tables, but I'm thinking there must be some easier way to get the info. in particular, I'm after the list of columns, their data types and lengths, null/non-null, default values, and table indices. thanks, michael __________________________________________________ Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/