I have no experience in postgres, and am trying to get a staging site correctly configured.
The database has a schema
data in the database
I imported the database from development using (as postgres user):
psql drupal <drupal.dump.sql
When I connect as the
drupal user, and execute
\dt, it only shows the regular tables and not the tables in the schema "data".
I see those "missing" tables when I execute
I am probably missing some permissions to be added to the drupal user. Any help greatly appreciated!
Postgres version: 9.3.17