example.yaml

# pgviewctl configuration example
#
# This file defines what database access to grant to an external service.
# All views are created in the target schema with least-privilege access.

# Target schema where all views will be created
target_schema: api

# DB user credentials from environment variables
# Set these before running pgviewctl:
#   export DB_SERVICE_USER=external_service
#   export DB_SERVICE_PASSWORD=your_secure_password
user_env: DB_SERVICE_USER
password_env: DB_SERVICE_PASSWORD

# Tables to expose as views
# Each entry creates a view in the target schema with only the specified columns
tables:
  # Simple case - all lowercase identifiers
  - name: customers
    source: public.customers
    columns: [id, name, city, created_at]

  # Mixed case - columns will be properly quoted
  - name: orders
    source: public.Orders
    columns: [id, customerId, totalAmount, orderDate]

  # Different source schema
  - name: user_profiles
    source: analytics.UserProfiles
    columns: [UserId, Email, CreatedAt]