stripe-archive / mosql

MongoDB → PostgreSQL streaming replication
MIT License
1.63k stars 225 forks source link

How to implement Foreign Key? #118

Open ShipraShalini opened 8 years ago

ShipraShalini commented 8 years ago

I have two collections in same mongo db. I wish to create two PostgreSQL tables using those (using the contents from both collections in both tables) and I want _id of the first as foreign key in the other table. Can it be done? Can you please share sample .YAML file for this?

aligajani commented 8 years ago

@ShipraShalini I have the same query, did you find a solution?

stewart-hector-whoknows commented 8 years ago

There appears to be no support for Foreign Keys.