Page 1 of 1

Register a new server and a new role in PostgreSQL

Posted: Mon 10 Nov 2014 15:51
by piopio1
Hello,

Is there a way to register a new server and a new role with DAC components ?

Many thanks
Pio Pio

Re: Register a new server and a new role in PostgreSQL

Posted: Tue 11 Nov 2014 07:24
by AlexP
hello,

Please clarify: what do you mean by "register a new server and a new role"?

Re: Register a new server and a new role in PostgreSQL

Posted: Tue 11 Nov 2014 10:51
by piopio1
AlexP wrote:hello,

Please clarify: what do you mean by "register a new server and a new role"?
Hi AlexP

For create role I mean create user http://www.postgresql.org/docs/9.2/stat ... euser.html


Just disregard the create server.

Thanks
Pio Pio

Re: Register a new server and a new role in PostgreSQL

Posted: Tue 11 Nov 2014 11:45
by AlexP
You can create a user/role (or any database object) by executing a correspondent script. You can execute the script in the ExecSQL method, for example:

Code: Select all

PgConnection1.ExecSQL('createuser joe');

Re: Register a new server and a new role in PostgreSQL

Posted: Tue 11 Nov 2014 14:45
by piopio1
AlexP wrote:You can create a user/role (or any database object) by executing a correspondent script. You can execute the script in the ExecSQL method, for example:

Code: Select all

PgConnection1.ExecSQL('createuser joe');
Thank you very much for your explanation, AlexP.

Pio Pio

Re: Register a new server and a new role in PostgreSQL

Posted: Wed 12 Nov 2014 05:21
by AlexP
You are welcome. Feel free to contact us if you have any further questions.