Re: Regarding extension

2019-10-08 Thread Craig Ringer
On Fri, 4 Oct 2019 at 13:18, Tom Lane wrote: > Natarajan R writes: > > Me: Thanks Tomas, But this is for that particular database only, I want > > to get the *list of database Id's* on which my extension is installed > > during *PG_INIT* itself... > > You can't. In the first place, that

Re: Regarding extension

2019-10-03 Thread Tom Lane
Natarajan R writes: > Me: Thanks Tomas, But this is for that particular database only, I want > to get the *list of database Id's* on which my extension is installed > during *PG_INIT* itself... You can't. In the first place, that information simply isn't obtainable, because a session running

Re: Regarding extension

2019-10-03 Thread Natarajan R
On Thu, 3 Oct 2019 at 20:54, Tomas Vondra wrote: > On Thu, Oct 03, 2019 at 07:51:04PM +0530, Natarajan R wrote: > >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

Re: Regarding extension

2019-10-03 Thread Tomas Vondra
On Thu, Oct 03, 2019 at 07:51:04PM +0530, Natarajan R wrote: 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

Re: Regarding extension

2019-10-03 Thread Natarajan R
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

Re: Regarding extension

2019-10-03 Thread Euler Taveira
Em qui, 3 de out de 2019 às 02:24, Natarajan R 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