Postgres custom schema flag in url

[mattes]

# TODO: thinking about adding some custom flag to allow migration within schemas:
-url="postgres://user@host:port/database?schema=name" 

[abourget]

afaik, the pq driver allows you to set search_path through the URL, so this would apply to the next CREATE TABLE statements. Would that be sufficient for your needs ?

I haven't tested that yet though, just a suggestion.

[mattes]

that would be cool. do you have a link to a reference?

[abourget]

http://godoc.org/github.com/lib/pq :)

Search the page for "search_path".. it's in there, but very subtle.

[adrienkohlbecker]

Hi,

For future developers stumbling on this issue while searching for a way to specify a schema, here is the syntax you have to use in the url options= -c search_path=my_schema which should be url-encoded as:

postgres://postgres:password@db:5432/my_db?options=+-c+search_path%3Dmy_schema

Note that the schema should already exist, and cannot be created via a migration.

For reference: https://github.com/lib/pq/blob/165a3529e799da61ab10faed1fabff3662d6193f/conn_test.go#L1341