gp_relfile_node gp_relfile_node The gp_relfile_node table contains information about the file system objects for a relation (table, view, index, and so on). Table 1. pg_catal...

CREATE AGGREGATE Synopsis Description Parameters Notes Examples Compatibility See Also CREATE AGGREGATE Defines a new aggregate function. Synopsis CREATE [ ORDERED ]...

COPY Synopsis Description Parameters Notes File Formats Examples Compatibility See Also COPY Copies data between a file and a table. Synopsis COPY <table> [(< col...

ALTER ROLE Synopsis Description Parameters Notes Examples Compatibility See Also ALTER ROLE Changes a database role (user or group). Synopsis ALTER ROLE <name> RENA...

Creating and Using Web External Tables Creating and Using Web External Tables CREATE EXTERNAL WEB TABLE creates a web table definition. Web external tables allow HAWQ to treat...

Creating and Using Web External Tables Creating and Using Web External Tables CREATE EXTERNAL WEB TABLE creates a web table definition. Web external tables allow HAWQ to treat...

Load the Data Load the Data Create the tables with SQL statements based on the appropriate schema. There are no special requirements for the HAWQ tables that hold loaded data....

pg_restore Synopsis Description Options Notes Examples See Also pg_restore Restores a database from an archive file created by pg_dump . Synopsis pg_restore [< genera...

gp_distribution_policy gp_distribution_policy The gp_distribution_policy table contains information about HAWQ tables and their policy for distributing table data across the s...

CREATE DATABASE Synopsis Description Parameters Notes Examples Compatibility See Also CREATE DATABASE Creates a new database. Synopsis CREATE DATABASE <database_name...