Thanks - works like a charm. Hmmm. I tried that earlier and got errors. I just retried and it worked fine this time. I guess I had some other problem - It seems that sometimes I have to exit and reenter my psql session to use a newly interpreted version of my stored procedure, so maybe that was part of the problem...
On Wed, Jan 10, 2018 at 6:34 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Jan 10, 2018 at 4:27 PM, Celia McInnis <celia.mcin...@gmail.com> > wrote: > >> Hi - Is it possible to create a table inside a plpython stored procedure? >> If so, can you give an example of how to do so? >> >> > Haven't used pl/python myself but... > > https://www.postgresql.org/docs/10/static/plpython-database.html > > so... plpy.execute("CREATE TABLE ...") ? > > David J. > >
