Request a Demo
16.2. Renaming an Analytical Table
Prev UpChapter 16. Analytical TablesHome Next

16.2. Renaming an Analytical Table #

Execute the following query: 

  SELECT metastore.rename_table('schema_name.current_table_name' or 'current_table_name', 'new_table_name');

Where:

  • schema_name: The name of the analytical schema where the table is created.

    Optional parameter. If you do not specify it, the current schema is used.

  • current_table_name: The current analytical table name.

  • new_table_name: The new unique analytical table name.

Example 16.3. 

  SELECT metastore.rename_table('testtable', 'testtable1');

Once the query is executed, pgpro_metastore performs the following actions:

  • Verifies user privileges.

  • Updates the table_name value for the analytical table in the pga_table metadata table.

  • Updates the view_sql value for the analytical table.

Prev Up Next
16.1. Creating an Analytical Table Home 16.3. Creating a Postgres Pro View From an Analytical Table
epub pdf