Обсуждение: 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
On 22/12/2014 10:48, moonkid@posteo.org wrote: > The list language is english, correct? Hello, Yes indeed. :-) > 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? Easiest way is to right-click on the "Tables" node, and then you should get a "New table" context menu item. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie
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 Spend 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. | ||||||
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
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@posteo.org" <moonkid@posteo.org>
To: pgadmin-support@postgresql.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
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support