Re: Multitenent architecture

From: Paul Förster <paul(dot)foerster(at)gmail(dot)com>
To: Vasu Madhineni <vasumdba1515(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Multitenent architecture
Date: 2020-06-05 06:37:42
Message-ID: F70EAB6D-8A2D-41D1-8FAA-8A72630013B0@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Vasu,

> On 04. Jun, 2020, at 17:52, Vasu Madhineni <vasumdba1515(at)gmail(dot)com> wrote:
> We are planning a POC on multitenant architecture in Postgres, Could you please help us with steps for multitenant using schema for each application model.

look up the docs for "create database" and "create schema":

https://www.postgresql.org/docs/current/sql-createdatabase.html
https://www.postgresql.org/docs/current/sql-createschema.html

PostgreSQL is by definition, what Oracle calls "multi tenant".

Cheers,
Paul

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2020-06-05 06:57:09 Re: Multitenent architecture
Previous Message Paul Förster 2020-06-05 06:21:39 Re: PostgreSQL 11 with SSL on Linux