Import to custom postgresql schema name (other then "public")

[alexey-gl]

Hello! Does osmosis support import to custom postgresql schema name? Browsing the code I didn't found such option except playing with postgres search_path setting.

[belug23]

HI @alexey-gl,

in theory it does support it if you give it the postgresSchema option at the command line as stated in the documentation, but it doesn't seem to work.

I've found your issue trying to find someone else that had done that did it successfully or trying to find more documentation on that functionality.

[belug23]

Ok, I've found my error, the user I was using didn't have access to the schema, so it wasn't able to find the tables.

If other people are trying to find how to do it, here's an example for the read option, other pgsql or pgsimp function work the same:

osmosis --read-pgsql database=<databasename> user=<username> password=<password> postgresSchema=<schema> --dataset-dump --write-pbf output.pbf

And don't forget to grant access to the space to the user you're using.