Re: [racket-users] Using schemas with the 'db' module

2016-10-06 Thread David Storrs
That works perfectly. Thanks, Ryan. On Thu, Oct 6, 2016 at 6:42 PM, Ryan Culpepper wrote: > In PostgreSQL, clusters contain databases contain schemas. > > I think the answer is to use "SET SCHEMA" or the more general "SET > search_path". See > > https://www.postgresql.org/docs/current/static/

Re: [racket-users] Using schemas with the 'db' module

2016-10-06 Thread Jon Zeppieri
Ah, my mistake. Thanks! > On Oct 6, 2016, at 6:42 PM, Ryan Culpepper wrote: > > In PostgreSQL, clusters contain databases contain schemas. > > I think the answer is to use "SET SCHEMA" or the more general "SET > search_path". See > > https://www.postgresql.org/docs/current/static/ddl-schemas

Re: [racket-users] Using schemas with the 'db' module

2016-10-06 Thread Ryan Culpepper
In PostgreSQL, clusters contain databases contain schemas. I think the answer is to use "SET SCHEMA" or the more general "SET search_path". See https://www.postgresql.org/docs/current/static/ddl-schemas.html https://www.postgresql.org/docs/current/static/sql-set.html Ryan On 10/06/2016 0

Re: [racket-users] Using schemas with the 'db' module

2016-10-06 Thread Jon Zeppieri
Isn't the #:database parameter in postgresql-connect what you're looking for? > On Oct 6, 2016, at 6:12 PM, David Storrs wrote: > > Is it possible to connect to a specific schema in a Postgres database, or to > set the current schema of an existing connection? > > The 'postgresql-connect' fu