Pavel Stehule wrote:
> Hi
>
> 2015-11-21 7:09 GMT+01:00 Praveen M <thrinz@gmail.com>:
>
> > Hi All,
> >
> > I am trying to get the schema name of the create function call from the
> > parse tree. When I look at the structure of the CreateFunctionStmt , I do
> > not see the schemaname information . Can you please help me to understand
> > how to extract the schema name for the function.
> The funcname field is >>list of names<<. Look on makeRangeVarFromNameList
> function. It is good example.
Of course, if your CREATE FUNCTION statement doesn't have the schema,
there is no way to know from the parsetree. This is where the deparse
infrastructure comes in, see commit b488c580aef.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services