Part III. Administration
This part describes the management of Postgres Pro AXE and its objects. For information about administering the Postgres Pro DBMS, refer to the official Postgres Pro documentation.
Table of Contents
- 12. Access Management
- 13. Secrets
- 14. Storages
- 15. DuckDB Extensions
- 16. Analytical Tables
- 17. Columns
- 18. Analytical Schemas
- 19. Shared Directories
- 20. Parquet Files
- 20.1. Adding Parquet Files to an Analytical Table (
metastore.add_files)- 20.2. Copying the Data from Heap Tables to an Analytical Table (
metastore.copy_table)- 20.3. Parquet File Storage Parameters
- 20.4. Marking Snapshots as Expired and Deleting Parquet Files
- 20.5. Deleting Intermediate Data (
metastore.cleanup)- 20.6. Retrieving Information About Cached Parquet Files
- 20.7. Checking a Parquet File for Corruption
- 20.2. Copying the Data from Heap Tables to an Analytical Table (
- 20.1. Adding Parquet Files to an Analytical Table (
- 21. JSON Data
- 21.1. Extracting a Value from JSON Data (
json_extract,json_extract_string)- 21.2. Validating JSON Data (
json_valid)- 21.3. Retrieving JSON Data Type (
json_type)- 21.4. Retrieving JSON Keys (
json_keys)- 21.5. Retrieving the JSON Structure (
json_structure)- 21.6. Checking a JSON Value (
json_contains)- 21.7. Retrieving the JSON Array Length (
json_array_length)- 21.8. Transforming JSON Data (
json_transform,json_transform_strict)- 21.9. Aggregating Values into a JSON Array (
json_group_array)- 21.10. Aggregating Values into a JSON Object (
json_group_object)- 21.11. Aggregating JSON Data into a Structure (
json_group_structure)- 21.12. Parsing and Removing Whitespace from JSON Data (
json) - 21.2. Validating JSON Data (
- 21.1. Extracting a Value from JSON Data (
- 22. MAP Data
- 22.1. Retrieving the Size of MAP Data (
cardinality)- 22.2. Retrieving a Value from MAP Data (
map_extract_value)- 22.3. Retrieving a Value from MAP Data as a List (
map_extract)- 22.4. Concatenating MAP Values (
map_concat)- 22.5. Checking a MAP Key (
map_contains)- 22.6. Checking a MAP Key-Value Pair (
map_contains_entry)- 22.7. Checking a MAP Value (
map_contains_value)- 22.8. Retrieving Key-Value Pairs from MAP Data (
map_entries)- 22.9. Retrieving Keys from MAP Data (
map_keys)- 22.10. Retrieving Values from MAP Data (
map_values)- 22.11. Creating MAP Data from Key-Value Pairs (
map_from_entries)- 22.12. Creating Empty MAP Data (
map) - 22.2. Retrieving a Value from MAP Data (
- 22.1. Retrieving the Size of MAP Data (
- 23. Data Sampling
- 24. Time-Based Data Analysis
- 24.1. Grouping Timestamps into Time Intervals (
time_bucket)- 24.2. Converting a Timestamp to a String (
strftime)- 24.3. Converting a String to a Timestamp (
strptime)- 24.4. Creating a Timestamp from Microseconds (
make_timestamp)- 24.5. Creating a Timestamp with Time Zone from Microseconds (
make_timestamptz) - 24.2. Converting a Timestamp to a String (
- 24.1. Grouping Timestamps into Time Intervals (
- 25. Direct DuckDB Commands
- 26. Metadata Catalog
- 27. Hive Partitioning
- 28. Maintenance