Make the changed status for postgres_db under CHECKMODE match the
status that would be returned normally.

Revert "No longer need to reference 'version_added' in docs for these, as this was quite a while ago."

This reverts commit ff0a41d4.

using pg_roles instead of pg_user
if database owner is a role (not user) then it can not select form pg_user table.

As of now, the documentation lists a parameter as "name",
whereas the examples use a parameter called "db". This brings
them in line.

  Migrated all examples: in DOCUMENTATION=''' string to standalone EXAMPLES=''' string
  Added deprecation warning to moduledev.rst and remove deprecated example from it
  Fixed up a few typos and uppercased some acronyms.
  add consistency to how EXAMPLES are formatted

Allow the specification of additional locale settings (lc_collate and lc_ctype) when creating a new database (state=present).

Fail if the specified database already exists with different locale/encoding settings. (These settings can't be changed for existing databases as far as I know, and failing seems better than suggesting that no change was necessary by returning changed=False)

 - added terse syntax to modules.rst
 - added description of special variables to template module

When initalizing a connection to psycopg2, in order to use the default
values, the keywords must be missing. So we use a dictionary as a kwarg
and include only the keywords that do not have an empty value on the
module parameters.

Add encoding lines to python modules such that they can take unicode options if they are fed them, since the
AnsibleModule stuff no longer base64 encodes for simplicity and speed reasons.

mysql_db: added 'encoding' and 'collation' args
postgresql_db: added 'owner', 'template' and 'encoding' args

Port the file module over to the new common code infrastructure + cleanup some redundant imports since the module code already imports those things.

passwd -> password
loginpass -> login_password
loginuser -> login_user
loginhost -> login_host

Add an example playbook that shows how to use the modules.

These modules are based on the mysql_db and mysql_user modules.

Currently, the postgresql_user module can only grant all permissions
on a database, fine-grained access has not been implemented yet.

Check file exists instead of relying on the exception. Leave the exception catch in, in case the file is deleted or some other issue crops up

Changing to read from a file pointer instead so that an exception is thrown if the file doesn't exist