sqlc-pg

README

sqlc-pg

sqlc-pg is a sqlc plugin for PostgreSQL using pgx Go driver.

Generated Code Examples

• authors
• booktest
• jets
• ondeck

sqlc Sample Configuration

• sqlc-pg must be available in your path
• Sample sqlc.yaml:

  version: "2"
  plugins:
    - name: sqlc-pg
      process:
        cmd: sqlc-pg
  sql:
    - engine: postgresql
      queries: query.sql
      schema: schema.sql
      codegen:
        - plugin: sqlc-pg
          out: sqlc
          options:
            emit_db_tags: true
            emit_exported_queries: false
            emit_params_struct_pointers: false
            emit_result_struct_pointers: false
            emit_table_names: true
            output_files_suffix: .gen