Which table(s) in the catalog define the tables and views?

From: Chris Velevitch <chris(dot)velevitch(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Which table(s) in the catalog define the tables and views?
Date: 2006-01-26 06:17:51
Message-ID: b0a3bf780601252217i2de2e883v672db3bf37f758d2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm want to write a query to list definitions of all the fields in my
tables and which table it belongs to. And similarly for views and
tables.

This is so I can check for table and column name consistency, extra
tables and column type consistency.

Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2006-01-26 06:26:17 Re: Which table(s) in the catalog define the tables and views?
Previous Message Patrick TJ McPhee 2006-01-26 04:15:18 Re: Temporary table visibility