This documentation is not maintained. Please refer to doc.castsoftware.com/technologies to find the latest updates.
On this page:
Summary: this page explains how to export DDL from a PostgreSQL database for use with the SQL Analyzer extension.
Extraction example - Windows
- Open a Command Prompt with "Run as Administrator" rights.
Switch to the PostgreSQL bin folder, e.g. :
cd "C:\Program Files\CAST\CASTStorageService2\bin"
Export a specific database:
REM pg_dump.exe -h <your postgres host> --username=operator --format plain --schema-only --schema=<your schema name> --port=<your postgres port> --file=<the name of the SQL (DDL) file> <database name> pg_dump.exe -h localhost --username=operator --format plain --schema-only --schema=castpubs --port=2280 --file=c:\temp\castpubsDDL.sql postgres
Note, don't forget the parameters:
--format plain : this will output a plain-text SQL script file
--schema-only : this will dump only the object definitions (schema), not data
Here is the process using the pgAdmin GUI:
Official documentation
Have a look at the official documentation for more details/parameters and examples: https://www.postgresql.org/docs/9.5/static/app-pgdump.html.