[sqlalchemy] Re: accessing functions in the postgres public schema using sqlalchemy.func

Yeah everything is working in psql just fine. select current_schema(); current_schema public (1 row) Time: 1.226 ms show search_path; search_path - "$user", public (1 row) select add(2,4); add - 6 (1 row) But you jogged my memory and think

Re: integrate with cherrypy / sqlalchemy

On Tue, Jul 31, 2018 at 3:12 AM, Amin M wrote: > Thanks Mike, really helped me out. > > I've done the following, in env.py > > import sys > import os > > project_root = os.path.abspath('./') # get Cherrypy root > sys.path.insert(0, project_root) # add it to Path, so we can import models, > and

Re: [sqlalchemy] accessing functions in the postgres public schema using sqlalchemy.func

On Wed, Aug 1, 2018 at 2:18 PM, Brian Cherinka wrote: > Hi, > > What's the best way to access functions that live in schema='public' in the > postgres databases? Some postgresql extensions install functions in the > public schema that I would like accessible via sqlachemy.func, however I get >

[sqlalchemy] accessing functions in the postgres public schema using sqlalchemy.func

Hi, What's the best way to access functions that live in schema='public' in the postgres databases? Some postgresql extensions install functions in the public schema that I would like accessible via *sqlachemy.func,* however I get an error when attempting to call them. Am I missing