Can we have two Postgres databases in same schema?

Question

I hope someone can help me to learn about Postgres schema and databases.

I have Postgres database called db1 and it has table calls table1. all these objects are in default schema called public.

Then I created another database called db2 and created another table with same name table1.

I didn't got any error but both tables are in same schema called public.

I created indexes for both of these tables and they both refer the table as public.table1.

I wonder a setup like this will give issue or not? If yes, then should I create different schemas for each database if I'm going to use same table names in all databases?

Mitya · Accepted Answer · 2023-04-13 11:57:06Z

3

In Postgres a database is the highest level "container". Then schemas follow. There can be schemas with the same name in different databases (but not in the same database). The other databases won't "see" them. So there is no problem in your setup.

edited Apr 13, 2023 at 11:57

Mitya

34.8k15 gold badges70 silver badges126 bronze badges

answered Mar 29, 2021 at 6:49

sticky bit

37.7k12 gold badges34 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

htaccess · Accepted Answer · 2022-09-12 04:58:11Z

3

Can we have two Postgres databases in same schema?

The answer is no. The relevant PostgreSQL documentation shows the hierarchy:

database.schema.table

This diagram (taken from this answer) is useful to visualise the relationship:

answered Sep 12, 2022 at 4:58

htaccess

3,1803 gold badges28 silver badges34 bronze badges

Collectives™ on Stack Overflow

Can we have two Postgres databases in same schema?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related