Re: Create table with GUI - Mailing list pgadmin-support
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.
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
pgadmin-support by date: