---
title: "pg_tables"
id: view-pg-tables
pg_version: "20devel"
---

<a id="view-pg-tables"></a>

## 53.34. pg_tables

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

**pg_tables Columns**

| Column Type | Description | 
| --- | --- |
| `schemaname` `name` (references [pg_namespace](catalog-pg-namespace.md).`nspname`) | Name of schema containing table |
| `tablename` `name` (references [pg_class](catalog-pg-class.md).`relname`) | Name of table |
| `tableowner` `name` (references [pg_authid](catalog-pg-authid.md).`rolname`) | Name of table's owner |
| `tablespace` `name` (references [pg_tablespace](catalog-pg-tablespace.md).`spcname`) | Name of tablespace containing table (null if default for database) |
| `hasindexes` `bool` (references [pg_class](catalog-pg-class.md).`relhasindex`) | True if table has (or recently had) any indexes |
| `hasrules` `bool` (references [pg_class](catalog-pg-class.md).`relhasrules`) | True if table has (or once had) rules |
| `hastriggers` `bool` (references [pg_class](catalog-pg-class.md).`relhastriggers`) | True if table has (or once had) triggers |
| `rowsecurity` `bool` (references [pg_class](catalog-pg-class.md).`relrowsecurity`) | True if row security is enabled on the table |