Re: [GENERAL] newbie question... how do I get table structure?

[Mark Gibson]

Aaron Bratcher wrote:

Is there no way I can do it with a standard select command in a 
different client? I don't need the indexes, just the column names/types.

For PostgreSQL 7.3 and above:

SELECT
   a.attname,
   format_type(a.atttypid, a.atttypmod)
FROM
   pg_catalog.pg_class c INNER JOIN
   pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) INNER JOIN
   pg_catalog.pg_attribute a ON (a.attrelid = c.oid)
WHERE
   n.nspname = '{schema_name}' AND
   c.relname = '{table_name}' AND
   a.attisdropped = false AND
   a.attnum > 0
Replace {schema_name} and {table_name}.

--
Mark Gibson <gibsonm |AT| cromwell |DOT| co |DOT| uk>
Web Developer & Database Admin
Cromwell Tools Ltd.
Leicester, England.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster