Re: How do I list the schema for a table or procedure? - Mailing list pgsql-general

From W. Scott Gibson
Subject Re: How do I list the schema for a table or procedure?
Date
Msg-id xaq_c.23$ax4.0@fe61.usenetserver.com
Whole thread Raw
In response to How do I list the schema for a table or procedure?  (googlemike@hotpop.com (Google Mike))
List pgsql-general
Google Mike wrote:
> How do I list the schema for a table or procedure? Is there a command
> I can do in psql to list this, or do I have to join a series of tables
> to see that?

You can do a "pg_dump -s <DBNAME>" to see the full schema of the
database.  To see just a table of the database issue the command
"pg_dump -st <TABLENAME> <DBNAME>".  These are run from the command line
and not within the psql shell.

Within psql you could use "\d <TABLENAME>" to describe a specific table.

pgsql-general by date:

Previous
From: John
Date:
Subject: Migrating from MaxDB to postgresql
Next
From: googlemike@hotpop.com (Google Mike)
Date:
Subject: Re: HOWTO: Get a table or database definition