如何为Laravel设置默认的Postgresql模式? [英] How to set default postgresql schema for laravel?

问题描述

我创建了一个新的postgresql用户:

I created new postgresql user:

CREATE ROLE lara_user SUPERUSER LOGIN PASSWORD 'mypassword';

然后创建该用户拥有的架构

Then create schema which is owned by this user

CREATE schema lara AUTHORIZATION lara_user;

在Laravel的.env文件中，我有

In Laravel's .env file I have

DB_DATABASE=postgres
DB_USERNAME=lara_user
DB_PASSWORD=mypassword

Laravel看不到架构lara，但仍连接到public架构.

Laravel don't sees schema lara and still connected to public schema.

如何更改和设置Laravel的默认架构lara?

How can I change and set default schema lara for Laravel ?

推荐答案

在app/config/database.php

'pgsql' => array(
            'driver'   => 'pgsql',
            'host'     => 'localhost',
            'database' => 'forge',
            'username' => 'forge',
            'password' => '',
            'charset'  => 'utf8',
            'prefix'   => '',
            'schema'   => 'public',
        ),

这篇关于如何为Laravel设置默认的Postgresql模式?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！