Postgres Pro AXE : Documentation: 1: Chapter 4. Quick Start : Postgres Professional

Chapter 4. Quick Start
Prev	Up	Part I. Overview	Home	Next

Chapter 4. Quick Start

To quickly configure and start using Postgres Pro AXE:

Install Postgres Pro AXE.
Configure the Postgres Pro AXE administrator.
Configure the metadata catalog:
1. Define a metadata catalog connection.
2. Initialize the metadata catalog.
(Optional) Configure an S3 storage:
1. Create a simple secret.
2. Create an S3 storage.

You can now start working with the data. The most frequent operations in Postgres Pro AXE are:

Creating a storage:

Example 4.1.

\! rm -rf /tmp/mt_storage/
\! mkdir -p /tmp/mt_storage/tmp/
SELECT metastore.add_storage('mt_storage', 'file:///tmp/mt_storage/', 'file:///tmp/mt_storage/tmp/');

For more detailed instructions, refer to Section 20.1.

Creating a heap table and inserting the data into it:

Example 4.2.

  CREATE TABLE my_table (id int4 NULL, "name" text NULL, price numeric(10,2) NULL, created_at timestamp NULL);
  INSERT INTO my_table VALUES (1, 'Product 1', 150.99, '2025-08-09 00:01:01.75');
  INSERT INTO my_table VALUES (1, 'Product 2', 300.99, '2025-08-10 00:01:01.75');

Creating an analytical table:
Example 4.3.
```
  SELECT metastore.add_table('mt_tbl_pg_schema', 'mt_storage', 'public.my_table');
```
For more detailed instructions, refer to Section 21.1.
Copying the data from a heap table to an analytical table:
Example 4.4.
```
  SELECT metastore.copy_table('mt_tbl_pg_schema', 'SELECT * FROM my_table');
```
For more detailed instructions, refer to Section 25.2.

Adding Parquet files to an analytical table:

Example 4.5.

  \! mkdir /tmp/pga_storage_dir_test/folder_path/
  COPY my_table TO '/tmp/mt_storage/folder_path/t.parquet';
  SELECT metastore.add_folder('folder_name', 'mt_storage', 'folder_path');
  SELECT metastore.add_files('mt_tbl_pg_schema', 'folder_name');

For more detailed instructions, refer to Section 24.1 and Section 25.1.

Creating a Postgres Pro view for an analytical table:
Example 4.6.
```
  SELECT metastore.create_view('mt_tbl_pg_schema');
```
For more detailed instructions, refer to Section 21.3.

Reading the data from the analytical table:

Example 4.7.

  SELECT * FROM mt_tbl_pg_schema;
  SELECT id, price FROM mt_tbl_pg_schema;

Renaming a column:
Example 4.8.
```
  SELECT metastore.rename_column('mt_tbl_pg_schema', 'id', 'newid');
```
For more detailed instructions, refer to Section 22.2.
Changing column data type:
Example 4.9.
```
  SELECT metastore.change_column_type('mt_tbl_pg_schema', 'newid', 'int64');
```
For more detailed instructions, refer to Section 22.3.
Deleting a column:
Example 4.10.
```
  SELECT metastore.delete_column('mt_tbl_pg_schema', 'created_at');
```
For more detailed instructions, refer to Section 22.4.
Deleting a Postgres Pro view:
Example 4.11.
```
  DROP VIEW mt_tbl_pg_schema;
```
Deleting an analytical table:
Example 4.12.
```
  SELECT metastore.remove_table('mt_tbl_pg_schema');
```
For more detailed instructions, refer to Section 21.4.
Deleting a shared directory:
Example 4.13.
```
  SELECT metastore.remove_folder('folder_name');
```
For more detailed instructions, refer to Section 24.2.
Deleting a storage:
Example 4.14.
```
  SELECT metastore.remove_storage('mt_storage');
```
For more detailed instructions, refer to Section 20.2.
Deleting a heap table:
Example 4.15.
```
  DROP TABLE my_table;
```

Prev	Up	Next
Chapter 3. Business Scenarios	Home	Part II. Deployment

epub pdf