💽

psqlでschema名を含めたURLに接続する

2022/12/28に公開

optionsに --serch_path で設定する

postgresql://${username}:${password}@localhost:${port}/${database}?options=--search_path%3D${schema}"

ref:
https://dba.stackexchange.com/questions/171855/how-to-set-a-search-path-default-on-a-psql-cmd-execution

Discussion