PostgreSQL

This skill covers PostgreSQL database operations using the PgQuery command-line tool for executing DDL scripts, managing schemas, and running queries against PostgreSQL databases.

Instructions

When helping users with PostgreSQL operations, follow these guidelines:

1. Always Use PgQuery Tool: Use Y:/CSharpDLLs/PgQuery/PgQuery.exe for all PostgreSQL operations. Never use psql or other PostgreSQL clients directly.

2. Configuration Files: PostgreSQL connection details are stored in JSON configuration files (typically in R:/JsonParams/). Common configs:

   • x3rocs_db.json - x3rocs database connection
   • dw_db.json - Data warehouse connection

3. Command Format: Use --config for database connection and either --file for SQL files or --sql for inline SQL:

   Y:/CSharpDLLs/PgQuery/PgQuery.exe --config "<config-path>" --file "<sql-file-path>"