Automatic SCHEMA creation in postgresql

Question

I’m having a problem with the following, I need to create a Rigger that when a given row is inserted it creates a SCHEMA with a specific structure! For example, in the public scheme, I have the client table, and when I insert some client, I need to create a Trigger with the client’s name.

INSERT INTO public.cliente (idcliente, nome) VALUES (2,'joao');

In that case, he would automatically create a SCHEMA with the name of John, but I have no idea how to do that.

I need to create a function that takes the SCHEMA name as parameter and within this function create the SCHEMA?

Answer 1

The fastest way is to make a script with some desired language.

Example in PHP:

// faz a conexão normal;

$VariavelQueRecebeNome = 'joao';

// executa o insert normalmente;

$sCriarSchema = "CREATE SCHEMA ".$VariavelQueRecebeNome."; ";

$rsQuery = pg_query($sCriarSchema);

There are "n" ways to do;