Обсуждение: Create table with GUI

Поиск
Список
Период
Сортировка

Create table with GUI

От
moonkid@posteo.org
Дата:
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



Re: Create table with GUI

От
Raymond O'Donnell
Дата:
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



Re: Create table with GUI

От
Melvin Davidson
Дата:
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

 
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@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