On Fri, Jan 16, 2009 at 9:32 PM, Vincent Predoehl
<vpredoehl@phoenixwebgroup.com> wrote:
> Does postgresql have a system table that has the table structure of user
> tables, like systables and sysobjects in MS SQL Server?
There's the pg_* views and tables that have all of that, and to see
how they work, you can run psql -E and then any \ command you issue
you'll get to see the SQL for.
OR you can look at the information_schema which is a SQL standard but
I think there are some pg relationships it can't show.