1: <?php namespace Laravel\Database\Connectors; use PDO;
 2: 
 3: class Postgres extends Connector {
 4: 
 5:     /**
 6:      * The PDO connection options.
 7:      *
 8:      * @var array
 9:      */
10:     protected $options = array(
11:             PDO::ATTR_CASE => PDO::CASE_LOWER,
12:             PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
13:             PDO::ATTR_ORACLE_NULLS => PDO::NULL_NATURAL,
14:             PDO::ATTR_STRINGIFY_FETCHES => false,
15:     );
16: 
17:     /**
18:      * Establish a PDO database connection.
19:      *
20:      * @param  array  $config
21:      * @return PDO
22:      */
23:     public function connect($config)
24:     {
25:         extract($config);
26: 
27:         $host_dsn = isset($host) ? 'host='.$host.';' : '';
28: 
29:         $dsn = "pgsql:{$host_dsn}dbname={$database}";
30: 
31:         // The developer has the freedom of specifying a port for the PostgresSQL
32:         // database or the default port (5432) will be used by PDO to create the
33:         // connection to the database for the developer.
34:         if (isset($config['port']))
35:         {
36:             $dsn .= ";port={$config['port']}";
37:         }
38: 
39:         $connection = new PDO($dsn, $username, $password, $this->options($config));
40: 
41:         // If a character set has been specified, we'll execute a query against
42:         // the database to set the correct character set. By default, this is
43:         // set to UTF-8 which should be fine for most scenarios.
44:         if (isset($config['charset']))
45:         {
46:             $connection->prepare("SET NAMES '{$config['charset']}'")->execute();
47:         }
48: 
49:         // If a schema has been specified, we'll execute a query against
50:         // the database to set the search path.
51:         if (isset($config['schema']))
52:         {
53:             $connection->prepare("SET search_path TO {$config['schema']}")->execute();
54:         }
55: 
56:         return $connection;
57:     }
58: 
59: }