webman-exercise/config/database.php

<?php
/**
 * This file is part of webman.
 *
 * Licensed under The MIT License
 * For full copyright and license information, please see the MIT-LICENSE.txt
 * Redistributions of files must retain the above copyright notice.
 *
 * @author    walkor<walkor@workerman.net>
 * @copyright walkor<walkor@workerman.net>
 * @link      http://www.workerman.net/
 * @license   http://www.opensource.org/licenses/mit-license.php MIT License
 */

return [
    'default' => 'pgsql',

    // all
    'connections' => [
        'pgsql' => [
            'driver' => 'pgsql',
            'host' => '127.0.0.1',
            'port' => 5432,
            'database'=> 'pgt1',
            'username'=> 'pgt1',
            'password'=> 'pgt1',
            'charset'=>'utf8',
            'prefix'=>'',
            'schema'=>'public',
            'sslmode'=>'prefer',
        ],

        // 'mysql' => [
        //     'driver' => 'mysql',
        //     'host'  => '127.0.0.1',
        //     'port' => 3306,
        //     'database' => 'test',
        //     'username' => 'root',
        //     'password' => '',
        //     'unix_socket' => '',
        //     'charset' => 'utf8',
        //     'collation' => 'utf8_unicode_ci',
        //     'prefix' => '',
        //     'strict' => true,
        //     'engine' => null,
        // ],
    ],
];