On Fri, Jan 16, 2009 at 9:32 PM, Vincent Predoehl <vpredoehl@xxxxxxxxxxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
