Combine various custom master tables into one master user

Question

I have tree projects running in production with three different databases Postgres

that manage their users individually and the tables are below.

Control Panel -> Database: salesDB, Table: user_master (id, name), other_table1, ...

Talent Panel -> Database: talentDB, Table: employee_master (id, name), other_table2, ...

Buyer Panel -> Database: buyerDB, Table: buyer_master (id, name), other_table3, ...

Now I want to manage all users in one new table by creating a new database for the admin panel.

Example: Admin Panel -> Database: adminDB, Tables: user_master (id, name)

Question:

1) If I create a new user_master table, how do I manage the existing original user id that is in use?

If there is another way please suggest me.

+3

database postgresql

Rahul Gupta June 30. 17 at 10:19

source to share

No one has answered this question yet

Check out similar questions:

4331

What is the difference between "INNER JOIN" and "OUTER JOIN"?

1591

PostgreSQL "DESCRIBE TABLE"

1522

Show tables in PostgreSQL

1031

How can I list tables in a SQLite database file that was opened with ATTACH?

904

How can I drop all tables in PostgreSQL database?

850

How to change PostgreSQL user password?

589

postgres: update user to become superuser?

4

is snowflake better than indexing?

0

Grant permissions to user where user can ALTER only tables created by him in Postgresql?

0

Insert or link to records based on the existence of a foreign table