Copy data to/from Ansible host

SUMMARY

Like \copy in psql, it would be nice to copy the data to/from the ansible_host instead of the PostgreSQL server. In psql afaik this is achieved using STDOUT / STDIN and redirection.

ISSUE TYPE

• Feature Idea

COMPONENT NAME

Module postgresql_copy.

ADDITIONAL INFORMATION

• Paths used in copy_from / copy_to should be allowed relative and be searched in ./files folder.
• An extra parameter should describe, whether to store the file on the database host (requires administrator rights) or local at the Ansible host.