Ecto.Adapters.Postgres
This is the adapter module for PostgreSQL. It handles and pools the connections to the postgres database with poolboy.
Options
The options should be given via Ecto.Repo.conf/0.
:hostname - Server hostname;
:port - Server port (default: 5432);
:username - Username;
:password - User password;
:size - The number of connections to keep in the pool;
:max_overflow - The maximum overflow of connections (see poolboy docs);
:parameters - Keyword list of connection parameters;
:ssl - Set to true if ssl should be used (default: false);
:ssl_opts - A list of ssl options, see ssl docs;
:lazy - If false all connections will be started immediately on Repo startup (default: true)
Summary
| query(repo, sql, params, opts \\ []) | Run custom SQL query on given repo |
Functions
Run custom SQL query on given repo.
Options
:timeout - The time in milliseconds to wait for the call to finish,
`:infinity` will wait indefinitely (default: 5000);Examples
iex> Postgres.query(MyRepo, "SELECT $1 + $2", [40, 2])
Postgrex.Result[command: :select, columns: ["?column?"], rows: [{42}], num_rows: 1]