![]() ![]() Let’s move on to step 2 to create the database. SQL: The SQL part gives the SQL equivalent of the operations performed. Parameters: In this section, if we want to define a parameter while creating the database, we can use it here. The Security tab is used to assign privileges and define security tags. Security: On the Security tab, there are security options. In the queries selected in this option, it has an important place in the features such as like order by, that is, the query order on text data. The pg_default tablespace is automatically created when the cluster is installed.Ĭollation: Collation is the part where we make the settings about how and according to which language the rows in the table are sorted.Ĭharacter Type: Selected as C. Tablespace: It is the part where the data written to the database is kept. ![]() In the template section, we specify which database to take as an example. It tries to encode the UTF-8 Unicode character set in the most efficient way, that is, taking up the fewest bytes. The most commonly used method for encoding Unicode characters is UTF-8. This conversion process is called encoding. When data is to be written to a file or passed over the network, it must be converted to bytes. UTF stands for Unicode Transformation Format. We make choices because of the characters they contain, so why utf-8 ? They are character sets, that is, they are character sets that are used to translate every letter and character we press from the keyboard into computer language. When we come to the definition part, the encoding part catches our eye first. (This is optional, you can not enter a description if you want.) In the comment section, we enter the description. When we do nothing, the postgres user comes up. In the Owner section, we select the database owner, that is, the user who is authorized to do everything in the database. In this window, we specify the database name in the tab that says database. Let’s examine the general tab in the opened window. Right click on the databases tab under the server we created and select the database tab in the create tab. I explained the connection via pgadmin and the necessary settings to connect in my other article, so I start with creating a database directly without going through it again. Let’s start by creating a database through the database Pg_admin, which is the first method. ![]() As I mentioned in the Command Line Database Operations tutorial, we can create a database with the createdb command. Creating a database with the help of psql clientĤ. Creating a database with pl\pgsql via pg_adminģ. There are 4 methods to create the database:Ģ. There are multiple methods and parameters when creating a database. ![]()
0 Comments
Leave a Reply. |