This page is not created by, affiliated with, or supported by Slack Technologies, Inc.
2021-09-21
Channels
- # admin-announcements (1)
- # announcements (6)
- # babashka (8)
- # beginners (134)
- # calva (18)
- # chlorine-clover (1)
- # cider (6)
- # circleci (6)
- # clj-commons (111)
- # cljsrn (13)
- # clojure (95)
- # clojure-australia (2)
- # clojure-europe (15)
- # clojure-nl (1)
- # clojure-spec (52)
- # clojure-uk (17)
- # clojurescript (4)
- # datavis (9)
- # datomic (8)
- # docker (2)
- # emacs (15)
- # events (7)
- # fulcro (6)
- # graphql (1)
- # gratitude (1)
- # introduce-yourself (2)
- # kaocha (8)
- # meander (87)
- # minecraft (2)
- # music (2)
- # off-topic (20)
- # portal (119)
- # releases (1)
- # reveal (55)
- # shadow-cljs (34)
- # sql (36)
- # tools-deps (9)
- # vim (8)
- # xtdb (39)
Hi everyone, does someone know how to change the PostgreSQL/Redshift schema using next.jdbc? Within my company I cannot use the default public schema and need to use something else, however can’t find how to set it as a config, or execute SET search_path = "other_schema"
(which would then be used in all future queries) thank you!
Would it not be possible to alter the user so that the search path is already set, i.e., alter user foo set search_path = 'other_schema, "$user", public';
?
unfortunately this is all I got from the IT department, I’m not sure if they would help me by executing that statement
in DataGrip I see the SET search_path statement executed as soon as I start querying the db ha
Aren't they there to support you? I mean, if you raise whatever ticket in your company to get them to action something for user on the db, they should honour the request?
currentSchema = String
Specify the schema (or several schema separated by commas) to be set in the search-path. This schema will be used to resolve unqualified object names used in statements over this connection.
@patrick.glind maybe this helps: https://github.com/seancorfield/next-jdbc/blob/develop/src/next/jdbc.clj#L115-L116
yeah, that is what I saw when I was hoping that the key/value would be submitted to the db