# axium_ddl_extractor.ps1

## Description
This script can be used on a database to generate a diffable DDL extract for the axiUm database. The DDL generated is not sufficient to run axiUm on its own because it is stripped of most customizations.

## Requirements
- PowerShell version 7
- EDB version of psql

## Usage
Run the script with the following parameters:

```powershell
.\axium_ddl_extractor.ps1 -port 15444 -user gold_schema_user -password pass -db gold_schema_db -schema gold_schema -superuser enterprisedb -superuserPassword pass
```

Replace the parameter values with your actual database details.

## Parameters

- `-dbHost`: The hostname or IP address of the PostgreSQL server (default: "localhost").
- `-port`: The port number of the PostgreSQL server (default: "5432").
- `-user`: The username to connect to the database.
- `-password`: The password for the specified user (optional, if not provided, uses environment or prompts).
- `-db`: The name of the database to connect to.
- `-schema`: The schema from which to extract the DDL.
- `-superuser`: The superuser username (used to install pg_get_tabledef if necessary).
- `-superuserPassword`: The password for the superuser (optional, similar to password).
