Register a new server and a new role in PostgreSQL

Discussion of open issues, suggestions and bugs regarding PgDAC (PostgreSQL Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
piopio1
Posts: 32
Joined: Thu 10 Jan 2013 23:13

Register a new server and a new role in PostgreSQL

Post by piopio1 » Mon 10 Nov 2014 15:51

Hello,

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

Many thanks
Pio Pio

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

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

Post by AlexP » Tue 11 Nov 2014 07:24

hello,

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

piopio1
Posts: 32
Joined: Thu 10 Jan 2013 23:13

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

Post by piopio1 » Tue 11 Nov 2014 10:51

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

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

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

Post by AlexP » Tue 11 Nov 2014 11:45

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');

piopio1
Posts: 32
Joined: Thu 10 Jan 2013 23:13

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

Post by piopio1 » Tue 11 Nov 2014 14:45

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

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

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

Post by AlexP » Wed 12 Nov 2014 05:21

You are welcome. Feel free to contact us if you have any further questions.

Post Reply