Re: Regarding extension

Thanks for your response Euler.

1)
"id" i meant by database id

I make my question simple, " during pg_init i want to get databaseid's in
which my extension is installed... "
1. by using pg_database and pg_extension catalogs
2. if there any other way, kindly suggest me.

2)
I have one sql file which will be loaded during create extension, in that
file only i have code for event trigger for create extension on
ddl_command_end event....
My question is "When giving create extension, sql file will be loaded at
that time only, if that is the case, this event trigger will be invoked or
not? "

Thanks...

On Thu, 3 Oct 2019 at 19:31, Euler Taveira <euler(at)timbira(dot)com(dot)br> wrote:

> Em qui, 3 de out de 2019 às 02:24, Natarajan R <nataraj3098(at)gmail(dot)com>
> escreveu:
> >
> > I am creating sample extension in postgres, For that "During PG_INIT, i
> want to get the list of database Id's in which my extension is installed".
> Is there a way to get this?
> >
> I'm not sure what you mean by "ld". However, if you want to know an
> extension is installed in a specific database, you should be logged in
> it. That's because extension catalog is not global.
>
> > How to have trigger for create extension?
> >
> Event triggers.
>
>
> --
> Euler Taveira Timbira -
> http://www.timbira.com.br/
> PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
>