I want to be able to build up information about the different tables held
in a database for a small diagnostic tool that I'm writing.
I need to see the name of each column in the table, the column data type
and size, and if nulls are allowed - essentially what is produced by the
'\d <tablename>' command.
Does anyone know the SQL query to use on the system tables to produce that
result? I've started to go through them now, and was expecting to find
something along the lines of 'pg_columns', but no such luck. :(
Knowledge Matters Limited
pgsql-general by date
|Next:||From: Imreet Singh||Date: 1999-09-27 13:23:09|
|Subject: Trouble with Innstalling PostGreSQL 6.5.2 on Win NT|
|Previous:||From: Otavio Exel||Date: 1999-09-27 12:38:56|
|Subject: libpq on win32 & postgresql on linux|