Option to use a uri like „postgres://user:password@host:port/database“

[dattito]

Your Question

Simple Question, but hard to find an answer online: Is there an option to use URIs instead of DSNs to connect to the database? This would make working with Heroku Postgres a lot easier!

The document you expected this should be explained

Expected answer

[jinzhu]

Maybe create an issue on pgx driver?

[ktarplee]

URI's already work with this driver in GORM since the underlying postgres driver already supports it. I use URI all the time for gorm/postgres. The only part that might not work is in this code base (but I have not hit an issue with it). It is this line

postgres/postgres.go

Line 65 in 6752fb0

result := regexp.MustCompile("(time_zone|TimeZone)=(.*?)($|&| )").FindStringSubmatch(dialector.Config.DSN)

It would be nice if the documentation was updated to point out that URIs do in fact work.