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}