Managing Data

This collection of topics provides information about using SQL commands, WarehousePG utilities, and advanced analytics integrations to manage data in your WarehousePG cluster.

• DDL: Defining Database Objects
  This topic covers data definition language (DDL) in WarehousePG and how to create and manage database objects.
• Working with External Data
  Both external and foreign tables provide access to data stored in data sources outside of WarehousePG as if the data were stored in regular database tables. You can read data from and write data to external and foreign tables.
• Loading and Unloading Data
  WarehousePG supports high-performance parallel data loading and unloading, and for smaller amounts of data, single file, non-parallel data import and export. The topics in this section describe methods for loading and writing data into and out of a WarehousePG, and how to format data files.
• SQL: Querying Data
  This topic provides information about using SQL queries to view, change, and analyze data in a database using the psql interactive SQL client and other client tools.
• Advanced Analytics
  WarehousePG offers a unique combination of a powerful, massively parallel processing (MPP) database and advanced data analytics. This combination creates an ideal framework for data scientists, data architects and business decision makers to explore artificial intelligence (AI), machine learning, deep learning, text analytics, and geospatial analytics.
• DML: Inserting, Updating and Deleting
  This topic provides information about manipulating data and concurrent access in WarehousePG.