Creating tables in GUI with pgAdmin4

Creating tables in GUI with pgAdmin4

It is now pgAdmin4 and the UI has changed a lot.

Here is how to create tables in the GUI.

pgAdmin4 でGUIでテーブルを作成する

In the “General” tab, specify the table name in “name” and pg_default in “Tablespace” for now.

Specify columns in the Columns tab.

pgAdmin4 でGUIでテーブルを作成する

You can create tables with “Save”.

By the way, the “SQL” tab is great because you can see the DDL.

pgAdmin4 でGUIでテーブルを作成する

In postgresSQL, strings are character varying.

コメント

タイトルとURLをコピーしました