Load Existing Tables

[jordanparker6]

I am trying to run Nocodb as a UI on an existing postgres db. After connecting it to the db, I cannot see the existing tables within a project. Does Nocodb offer this feature? I cannot see it in the docs.

Thanks

[o1lab]

Hey, that is supported. Could you please paste project info ?

• Recreate the project one more time to confirm the problem. This is since - if you would change the project name before saving it would have changed the schema name hence you might be looking at an empty schema.
• Is it the public schema in which tables are present ? if not then this is how you connect to it.
• Please reach out on discord - Im happy to help.

[jordanparker6]

Thanks for your help. Unfortunately, I cannot connect still.

I am trying to connect to public schema. I have added "searchPath": ["public"] to the settings.json. Still no dice...

I have created a seperate user for nocodb in postgres. Would this be creating any issues?

[o1lab]

Reach out on our discord - happy to help : https://discord.gg/5RgZmkW

[o1lab]

This was an issue with connected database user not having the permission to read the tables.