11-create-table.yaml

apiVersion: batch/v1
kind: Job
metadata:
  name: create-table-right
spec:
  template:
    spec:
      containers:
      - name: execute-qry
        env:
        - name: PGHOST
          value: cockroachdb-public.cockroachdb.svc.cluster.local
        - name: PGUSER
          value: migration-user
        - name: PGPASSWORD
          value: migrationpw
        - name: PGPORT
          value: "26257"
        - name: DATABASE
          value: example-db
        - name: PGCONNECT_TIMEOUT
          value: "3"
        image: postgres:latest
        command: [
          "bash" , "-c", 
          "psql --host=$PGHOST --user=$PGUSER --port=$PGPORT --dbname=$DATABASE -c \"CREATE TABLE app1.sometable(some_id serial PRIMARY KEY, some_name VARCHAR (255));\""
        ]
      restartPolicy: Never
  backoffLimit: 1