## What does Atlan crawl from PostgreSQL?

URL: https://docs.atlan.com/apps/connectors/database/postgresql/references/what-does-atlan-crawl-from-postgresql

> During a PostgreSQL crawl, Atlan extracts metadata for Databases, Schemas, Tables, Views, and Functions. Reference tables map each PostgreSQL property to its Atlan asset.

During a PostgreSQL crawl, Atlan extracts metadata for Databases, Schemas, Tables, Views, and Functions and maps it to Atlan's internal asset model. The tables below list, for each asset type, which PostgreSQL properties are read and how they appear on the corresponding Atlan asset.

Once you have [crawled PostgreSQL](https://docs.atlan.com/llms/connectors/postgresql/crawl-postgresql/llms.txt), you can [use connector-specific filters](https://docs.atlan.com/llms/catalog/discovery/use-the-filters-menu/llms.txt) for quick asset discovery.

## Databases

Atlan maps databases from PostgreSQL to its `Database` asset type.

| Source property | Atlan property |
| --- | --- |
| `TABLE_CATALOG` | `name` |
| `SCHEMA_COUNT` | `schemaCount` |

## Schemas

Atlan maps schemas from PostgreSQL to its `Schema` asset type.

| Source property | Atlan property |
| --- | --- |
| `TABLE_SCHEMA` | `name` |
| `TABLE_COUNT` | `tableCount` |
| `VIEW_COUNT` | `viewsCount` |
| `TABLE_CATALOG` | `databaseName` |

## Tables

Atlan maps tables from PostgreSQL to its `Table` asset type.

| Source property | Atlan property |
| --- | --- |
| `TABLE_NAME` | `name` |
| `REMARKS` | `description` |
| `COLUMN_COUNT` | `columnCount` |
| `ROW_COUNT` | `rowCount` |
| `BYTES` | `sizeBytes` |
| `TABLE_KIND (p)`, `TABLE_TYPE (PARTITIONED TABLE)` | `isPartitioned` |
| `PARTITION_STRATEGY` | `partitionStrategy` |
| `PARTITION_COUNT` | `partitionCount` |
| `IS_INSERTABLE_INTO` | `is_insertable_into` |
| `IS_TYPED` | `is_typed` |
| `SELF_REFERENCING_COL_NAME` | `self_referencing_col_name` |
| `REF_GENERATION` | `ref_generation` |
| `IS_TRANSIENT` | `is_transient` |

## Table partitions

Atlan maps table partitions from PostgreSQL to its `TablePartition` asset type.

| Source property | Atlan property |
| --- | --- |
| `TABLE_NAME` | `name` |
| `REMARKS` | `description` |
| `COLUMN_COUNT` | `columnCount` |
| `ROW_COUNT` | `rowCount` |
| `BYTES` | `sizeBytes` |
| `PARTITION_CONSTRAINT` | `constraint` |
| `TABLE_KIND (p)`, `TABLE_TYPE (PARTITIONED TABLE)` | `isPartitioned` |
| `PARTITION_STRATEGY` | `partitionStrategy` |
| `PARTITION_COUNT` | `partitionCount` |
| `IS_INSERTABLE_INTO` | `is_insertable_into` |
| `IS_TYPED` | `is_typed` |
| `SELF_REFERENCING_COL_NAME` | `self_referencing_col_name` |
| `REF_GENERATION` | `ref_generation` |
| `IS_TRANSIENT` | `is_transient` |

## Views

Atlan maps views from PostgreSQL to its `View` asset type.

| Source property | Atlan property |
| --- | --- |
| `TABLE_NAME` | `name` |
| `REMARKS` | `description` |
| `COLUMN_COUNT` | `columnCount` |
| `VIEW_DEFINITION` | `definition` |
| `IS_INSERTABLE_INTO` | `is_insertable_into` |
| `IS_TYPED` | `is_typed` |
| `SELF_REFERENCING_COL_NAME` | `self_referencing_col_name` |
| `REF_GENERATION` | `ref_generation` |
| `IS_TRANSIENT` | `is_transient` |

## Materialized views

Atlan maps materialized views from PostgreSQL to its `MaterialisedView` asset type.

| Source property | Atlan property |
| --- | --- |
| `TABLE_NAME` | `name` |
| `REMARKS` | `description` |
| `COLUMN_COUNT` | `columnCount` |
| `ROW_COUNT` | `rowCount` |
| `BYTES` | `sizeBytes` |
| `VIEW_DEFINITION` | `definition` |

## Columns

Atlan maps columns from PostgreSQL to its `Column` asset type.

| Source property | Atlan property |
| --- | --- |
| `COLUMN_NAME` | `name` |
| `REMARKS` | `description`

---