[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Are there commands to enquire about table structure?
From:       "Ben" <reply () to-the-newsgroup ! com>
Date:       2004-01-31 20:11:19
Message-ID: 14c4c4e8ac7903b0085b81457b69c158 () news ! teranews ! com
[Download RAW message or body]

On Sat, 31 Jan 2004 02:22:09 +0000, Lee Harr wrote:

> In 7.4 anyhow, I bet you can do much of this with the
> information_schema. This one would be ...
> 
> SELECT count(*)
>     FROM information_schema.columns
>     WHERE table_name='mytable';

Sounds very good; however, the DB in question is 7.3.2 - no such namespace
exists there. If we can get the IP people to sign off on upgrading, I'll
look into this mechanism. We've got megabytes of SQL designed for
Postgres, though, and any changes have to be vetted against the whole
system before we can use them, something that takes many months.

--Ben



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
[prev in list] [next in list] [prev in thread] [next in thread]