Copy data to/from Ansible host

[alehaa]

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.

[alehaa]

It would be cool to see this feature for other modules using files (e.g. postgresql_db) too.

[Andersson007]

@alehaa hi, thanks for the feedback! I'll put labels that the issue is vacant for review and implementation (if there's a consensus among reviewers)