Skip to main content
pgschema supports loading configuration from environment variables and dotenv .env files.

​
Overview

pgschema automatically loads configuration from:
  1. .env file in the current directory (if present)
  2. System environment variables
  3. Command-line flags (highest priority)
The precedence order is: CLI flags > environment variables > defaults

​
Supported Environment Variables

pgschema supports all standard PostgreSQL environment variables:
​
string
default:"localhost"
Database server host
​
integer
default:"5432"
Database server port
​
string
required
Database name (required for all commands)
​
string
required
Database user name (required for all commands)
​
string
Database password
​
string
default:"prefer"
SSL mode for database connection. Valid values: disable, allow, prefer, require, verify-ca, verify-full
​
string
default:"pgschema"
Application name visible in pg_stat_activity

​
.env Setup

Create a .env file in your project directory:
Security Note: Add .env to your .gitignore file to prevent committing sensitive credentials: