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.

コメント

Discover more from 株式会社CONFRAGE ITソリューション事業部

Subscribe now to keep reading and get access to the full archive.

Continue reading

Copied title and URL