I am looking to connect and query to a PostgreSQL. But I only want to connect to a particular Schema.
As per the doc (JDBC) we can use
or update As of 9.4 you can specify the url with the new currentSchema parameter like so:
But I am unable to do so with golang SQL driver;
As per the documents, we can also use
SET search_path TO myschema,public;
But I only want to declare it for once during initializing but I think this needs to be executed every time for new connection.
Also I am using following code please help me identify the correct parameters to be passed to this in order to only connect with schema
db, err := sql.Open("postgres", `dbname=`+s.settings.Database+ ` user=`+s.settings.Username+` password=`+s.settings.Password+ ` host=`+s.settings.Url+` sslmode=disable`)
searchpath=myschema is not working!
Is there a way I can only connect to a particular database-schema in GO