community.general.postgresql_table – Create, drop, or modify a PostgreSQL table

• Synopsis
• Requirements
• Parameters
• Notes
• See Also
• Examples
• Return Values

Synopsis

• Allows to create, drop, rename, truncate a table, or change some table attributes.

Requirements

The below requirements are needed on the host that executes this module.

• psycopg2

Parameters

Notes

See Also

Examples

- name: Create tbl2 in the acme database with the DDL like tbl1 with testuser as an owner
  community.general.postgresql_table:
    db: acme
    name: tbl2
    like: tbl1
    owner: testuser

- name: Create tbl2 in the acme database and tablespace ssd with the DDL like tbl1 including comments and indexes
  community.general.postgresql_table:
    db: acme
    table: tbl2
    like: tbl1
    including: comments, indexes
    tablespace: ssd

- name: Create test_table with several columns in ssd tablespace with fillfactor=10 and autovacuum_analyze_threshold=1
  community.general.postgresql_table:
    name: test_table
    columns:
    - id bigserial primary key
    - num bigint
    - stories text
    tablespace: ssd
    storage_params:
    - fillfactor=10
    - autovacuum_analyze_threshold=1

- name: Create an unlogged table in schema acme
  community.general.postgresql_table:
    name: acme.useless_data
    columns: waste_id int
    unlogged: true

- name: Rename table foo to bar
  community.general.postgresql_table:
    table: foo
    rename: bar

- name: Rename table foo from schema acme to bar
  community.general.postgresql_table:
    name: acme.foo
    rename: bar

- name: Set owner to someuser
  community.general.postgresql_table:
    name: foo
    owner: someuser

- name: Change tablespace of foo table to new_tablespace and set owner to new_user
  community.general.postgresql_table:
    name: foo
    tablespace: new_tablespace
    owner: new_user

- name: Truncate table foo
  community.general.postgresql_table:
    name: foo
    truncate: yes

- name: Drop table foo from schema acme
  community.general.postgresql_table:
    name: acme.foo
    state: absent

- name: Drop table bar cascade
  community.general.postgresql_table:
    name: bar
    state: absent
    cascade: yes

Return Values

Common return values are documented here, the following are the fields unique to this module:

Authors

• Andrei Klychkov (@Andersson007)