Describe Redis cache table
describe_redis_cache_tableInspect a Redis-backed foreign table in PostgreSQL to reveal its server mapping, key type, prefix, TTL, and column definitions. Use it to understand the underlying Redis cache structure.
Instructions
Describe one foreign table backed by redis_fdw: which server it's mapped to, the Redis-side key structure (hash / list / string / set / zset), key-prefix, TTL, and SQL-side column shape. Raises an error when the table doesn't exist or isn't backed by redis_fdw. Returns an object with schema, name, server, key_type, key_prefix, ttl_seconds, columns (list of {name, data_type}), and options (the full foreign-table options dict).
Example: describe_redis_cache_table(schema='public', table='sessions_cache')
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 |
|---|---|---|---|
| name | Yes | ||
| schema | Yes | ||
| server | Yes | ||
| columns | Yes | ||
| options | Yes | ||
| key_type | Yes | ||
| key_prefix | Yes | ||
| ttl_seconds | Yes |