Install Drupal database in specific PostGreSQL schema
NickName:Parth Doshi Ask DateTime:2019-05-25T16:16:38

Install Drupal database in specific PostGreSQL schema

I want to install & setup my Drupal databases in a specific schema of the PostgreSQL database. For example, let's say I have created a schema named "test_drupal" in my existing PostGreSQL database and want all Drupal tables such as "block_content", "block_content_field_data" etc. inside my schema.

I also tried specifying the prefix while doing the database setup through Advanced options but it is only adding a prefix before the table names. Ideally I want to put all my tables in a specific schema in PostGreSQL. How can prefix be used in this case?

Can someone please help?

I am using drupal version 8.7.1

Regards, Parth

Copyright Notice：Content Author:「Parth Doshi」，Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/56303071/install-drupal-database-in-specific-postgresql-schema

Products recommended by Amazon
More >>>
SanDisk 128GB microSDXC-Card, Licensed for Nintendo-Switch - SDSQXAO-128G-GNCZN
SanDisk 128GB microSDXC-Card, Licensed for Nintendo-Switch - SDSQXAO-128G-GNCZN
 HUANUO Dual Monitor Stand - Adjustable Spring Monitor Desk Mount Swivel Vesa Bracket with C Clamp, Grommet Mounting Base for 13 to 27 Inch Computer Screens - Each Arm Holds 4.4 to 14.3lbs
HUANUO Dual Monitor Stand - Adjustable Spring Monitor Desk Mount Swivel Vesa Bracket with C Clamp, Grommet Mounting Base for 13 to 27 Inch Computer Screens - Each Arm Holds 4.4 to 14.3lbs
 AMD Ryzen 5 5600X 6-core, 12-Thread Unlocked Desktop Processor with Wraith Stealth Cooler
AMD Ryzen 5 5600X 6-core, 12-Thread Unlocked Desktop Processor with Wraith Stealth Cooler
 Timberland Men's 6-Inch Premium Waterproof Boot
Timberland Men's 6-Inch Premium Waterproof Boot
More about “Install Drupal database in specific PostGreSQL schema” related questions
Install Drupal database in specific PostGreSQL schema

I want to install & setup my Drupal databases in a specific schema of the PostgreSQL database. For example, let's say I have created a schema named "test_drupal" in my existing PostGreSQL datab...

Show Detail
PostgreSQL: Create schema in specific database [NOT psql]

Im trying to create a SQL file to import my database/schema/tables with PHP. If I use the PgAdmin, it inserts a meta-command \connect after the CREATE TABLE and this generates an error if I run th...

Show Detail
Drupal 6 module install file not creating tables in database

I'm using the Schema API to create tables for my module on Drupa 6.17, but the tables just do not get created in the database. I have the Schema module installed, and it tells me that while the sch...

Show Detail
Install Drupal 8.x PostgreSQL

Tell me, how to install Drupal 8.1.9 or 8.2.0 with PostgreSQL? Interestingly, in earlier versions, when the installation was attended by a selection of PostgreSQL. In newer versions this is even no

Show Detail
How migrate to specific schema of database PostgreSQL working with Symfony and Doctrine?

I did a migration after of created my database structure using make:entity command : $ symfony console make:migration Now, I want to migrate to a specific schema into my PostgresSQL database. In ...

Show Detail
Access a specific schema in a PostgreSQL database via PHP

I have a PostgreSQL database userdb with 5 schemas. Schema 1- Persons Schema 2- Project Schema 3- Shop Schema 4- Test I was able to connect to the database using pg_connect. How do I access a sp...

Show Detail
Access a specific schema in a PostgreSQL database via PHP

I have a PostgreSQL database userdb with 5 schemas. Schema 1- Persons Schema 2- Project Schema 3- Shop Schema 4- Test I was able to connect to the database using pg_connect. How do I access a sp...

Show Detail
PostgreSQL: Create schema in specific database

I need to write an sql script that creates both a new database AND a new schema in the database I just created. How can I do it? Can I somehow change the current database to the new one? Or can I

Show Detail
Drupal 6 module install file not creating tables in database with Different table name

I'm using the following code to create a database schema using the .install file in drupal-6 function myModule_install() { // Create tables. drupal_install_schema('table_name'); } Let's say,...

Show Detail
Create New Database and a Schema in new database using Sql Script in PostgreSQL

I am trying to create a new database and a schema in the new database using Sql script as below. The database is PostgreSql 14.1 DROP DATABASE IF EXISTS DEZDAZ; CREATE DATABASE DEZDAZ ...

Show Detail