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.

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

Specify columns in the Columns tab.

You can create tables with “Save”.

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

In postgresSQL, strings are character varying.

高橋