Re: Create table with GUI

The Graphical _QUERY_ Builder in the SQL Editor will only allow you to create QUERIES. It cannot be used to create tables.
You can also create objects in the tree view.If you right click on Databases, you can create another database.If you Click on the Plus (+) sign next to the Database in the tree view,you will see Catalogs, Extensions & Schemas.If you right click on Schemas, you can create more Schemas.
Tables are created in Schemas. So right click on a schema and you will
see the option to create a table.
After you create a table, you can Click on the Plus (+) sign next to the Schema to see the created table.
There is also a video tutorial that walks you through the whole process.
How to Create a Postgres Database Using pgAdmin | EnterpriseDB
|   |
|   |   |   |   |   |
| How to Create a Postgres Database Using pgAdmin | EnterpriseDBSpend 10 minutes with Gary as he walks through the basics of creating your first database using pgAdmin, the comprehensive database design and management console for Postgres databases. |
| |
| View on www.enterprisedb.com | Preview by Yahoo |
| |
|   |

 Melvin Davidson

I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

Folk Alley - All Folk - 24 Hours a day
www.folkalley.com

From: "moonkid(at)posteo(dot)org" <moonkid(at)posteo(dot)org>
To: pgadmin-support(at)postgresql(dot)org
Sent: Monday, December 22, 2014 5:48 AM
Subject: [pgadmin-support] Create table with GUI

The list language is english, correct?

I am using PostGreSql9.3 on Kubuntu14.04 with pgAdmin III (release
1.18.1).
I have a conected but empty databse in there.

I want to create a table with the GUI (not SQL!). In the office docu of
pgAdmin I miss the topic "Create a table".
All descriptions and tutorials in the web describe it with SQL. I know
SQL but don't want to use it for such a simple task. I don't need a GUI
to use SQL. ;)

The point is I don't understand the elements/items of the TreeView. I
miss the documentation about it, too.
There is my "database" and under it is "Schemata -> public -> tables".
But....
Beside (on the same tree-level) my "database" is "Tablespaces".

Where can I create my own tables? Maybe you can link the documentation
about the description of the tree-elements?

Thank you very much
Christian