w3-tools.com - Free Webmaster Tools and Resources
  		w3-tools.com - Free Webmaster Tools and Resources
 Free Webmaster Tools and Resources

 



PostgreSQL Manual

This manual is provided as a courtesy. It is not an official source. Please check postgresql.org for updated information.

PostgreSQL Manual

PostgreSQL Manual
PostgreSQL 8.1.3 Documentation
PrevFast BackwardChapter 42. System CatalogsFast ForwardNext

42.44. pg_tables

The view pg_tables provides access to useful information about each table in the database.

Table 42-44. pg_tables Columns

NameTypeReferencesDescription
schemanamenamepg_namespace.nspnamename of schema containing table
tablenamenamepg_class.relnamename of table
tableownernamepg_authid.rolnamename of table's owner
tablespacenamepg_tablespace.spcnamename of tablespace containing table (NULL if default for database)
hasindexesbooleanpg_class.relhasindextrue if table has (or recently had) any indexes
hasrulesbooleanpg_class.relhasrulestrue if table has rules
hastriggersbooleanpg_class.reltriggerstrue if table has triggers
PrevHomeNext
pg_statsUppg_user

Newsletter
Join to our newsletter and receive news and updates about our site.
Your name: 
E-mail address: 
Action: 
 

Hosted by

Search
Google
Web w3-tools.com

Links
  What is my IP? Find your IP address!     Valid XHTML 1.0 Transitional  
Copyright © 2006. by w3-tools.com. All rights reserved