Devart Forums

Hi,
sorry my english is bad
I download demo MyDac for Delphi 2010
and I download PgDacDemo
... but, this programm very difficult for me

I'm fish

I have Delphi 2010 and postgresql 8.3
How to create database?


I have placed PgConnection1 on my form and add procedure

1)
procedure TForm1.Button1Click(Sender: TObject);
begin
PgConnection1.username:=edit1.text;
PgConnection1.password:=edit2.text;
PgConnection1.database:=edit3.text;
PgConnection1.connected:=true;
end;


Please, prompt what next steps ?
2)...
3)...
4)...

Help me, please...

Hello,

To create a database you can use the following code:

PgConnection1.Server:= 'YOUR_SERVER';
PgConnection1.Port:=5432;//<-- your port number
PgConnection1.Username:= 'your_user_name';
PgConnection1.Password:= 'your_password';
PgConnection1.Connect;
PgConnection1.ExecSQL('CREATE DATABASE test_db WITH OWNER = your_owner ENCODING = ''UTF8''',[null]);

Or you can use the standard PostgreSQL tool PgAdmin.

Thank you, AlexP ^^

AlexP wrote:Hello,

To create a database you can use the following code:

PgConnection1.Server:= 'YOUR_SERVER';
PgConnection1.Port:=5432;//<-- your port number
PgConnection1.Username:= 'your_user_name';
PgConnection1.Password:= 'your_password';
PgConnection1.Connect;
PgConnection1.ExecSQL('CREATE DATABASE test_db WITH OWNER = your_owner ENCODING = ''UTF8''',[null]);

Or you can use the standard PostgreSQL tool PgAdmin.

sorry,
what is "your_owner" ?

Please, write this string for example" PgConnection1.ExecSQL('CREATE DATABASE test_db WITH OWNER = your_owner ENCODING = ''UTF8''',[null]);"

I don't sleep two days

Hello,

OWNER is the username of the new owner of the table.

You can read more information about PostgreSQL commands at the official PostgreSQL site or in the PostgreSQL documentation.

For example, your username is "sanya", then you can use the following code to create a database:

PgConnection1.ExecSQL('CREATE DATABASE test_db WITH OWNER = sanya ENCODING = ''UTF8''',[null]);

Thanks !!!