How to create function for each database in multitenant architecture

Sorry, mate.

 

You didn't mention the db and I assumed it could be SQL Server.

 

Unfortunately, may not be able to help PostgreSQL.

Nitin 

   i am using postgres sql i have create the database for the multitenant my question is can we create generic funcion who run for each database sepratly but the function is only one it's not replicated.
i have used dblink_exec function and tryed but can't able to create at the time of the datbase creation.

is there any other way or any idea. pls suggest thanks. 

Exactly the same way how you created table.

 

If you are using Microsoft SQL Server and if you are okay with it, you can created objects in model database.

 

When new database is created, model database is used as a source.

 

So everytime you create a new database, all the objects in model database will be in new db as well.

 

Hope it helps!