I'm trying to create a schema on a postgres instance located on Amazon rds.
That schema would be used to import data from an existing schema built on a local db.
Issue is I do not have permissions to create schemas on RDS.
dw_etl I'm using to connect to the postgres instance has the role
rds_superuser, which is similar to the
dw_etl should be able to create new schemas.
- Is there a way to create schemas with RDS?
- If I cannot create schemas on RDS, what would be the best way to "silos" the data? Will the
publicschema became some kind of dump?