I have the following use case: I’m connecting Strapi to an existing postgres db and I want to have some content types that fetch the data from existing table. How can I do it?
Just to me clear, for example:
- my database already has a table skill under the public schema (postgres schema I mean). Here the table is public.skills
- I’m using strapi to create a content-type called Course under the strapi schema (postgres schema I mean). Here the table is strapi.courses
Since the courses could have one or more skills I don’t want to replicate the skill table under the strapi schema but I’d like that the Skill content type reads and writes on the existing table.
Is something that Strapi is able to do?