| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Cc: | Praveen M <thrinz(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: CreateFunction Statement |
| Date: | 2015-11-21 11:59:02 |
| Message-ID: | 20151121115902.GQ614468@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Pavel Stehule wrote:
> Hi
>
> 2015-11-21 7:09 GMT+01:00 Praveen M <thrinz(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2015-11-21 14:30:17 | Re: Error with index on unlogged table |
| Previous Message | Emre Hasegeli | 2015-11-21 09:26:04 | Re: new full text search configurations |