Common Greenplum Queries and Commands
Data Export and Import
Greenplum provides several ways to export and import data using standard PostgreSQL tools like pg_dump and psql. Here are some common commands:
Export only table structure:```
pg_dump -U gpadmin -d datawarehouse -w -s > /tmp/tab.sql
Export specific table structure:```
pg_dump -U postgres -d postgres -w -s -t test_ta ...
Posted on Thu, 11 Jun 2026 18:47:47 +0000 by jandrews