Describe AO table
describe_ao_tableInspect append-optimized or columnar storage metadata for a table: orientation, compression type/level, block size, checksum. Returns false if table is heap or if the database lacks the feature.
Instructions
Describe append-optimized (AO) / append-optimized columnar (AO/CO) storage metadata for one table: row vs column orientation, compression_type, compression_level, block_size, checksum. Reads pg_appendonly. Returns is_ao=false cleanly when the table is a regular heap. Read-only. On vanilla PG returns available=false.
Example: describe_ao_table(schema='public', table='events_ao')
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| schema | Yes | ||
| database | No | Optional: target a configured secondary (read-only) database by name; omit for the primary. Call list_databases to see the configured ids. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| is_ao | Yes | ||
| table | Yes | ||
| detail | Yes | ||
| schema | Yes | ||
| checksum | Yes | ||
| columnar | Yes | ||
| block_size | Yes | ||
| compression_type | Yes | ||
| compression_level | Yes |