From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | Bob Pawley <rjpawley(at)shaw(dot)ca>, Pgadmin-Support <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: [GENERAL] PG Admin |
Date: | 2007-07-31 16:45:23 |
Message-ID: | 46AF6723.7020806@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support pgsql-general |
On 31/07/2007 17:32, Bob Pawley wrote:
> I right click on the PG Admin "Tables" under the schema in which I want
> the new table, choose 'New Table" and fill in the spaces Name, owner,
> columns and click 'has oids'. Thge table is created and viewable through
> PG Admin and in the correect schems.
No reason why it shouldn't be visible to all other clients after this -
once you click 'OK' and it all works, the DDL has been committed and the
new object is visible to everyone.
> Someone mentioned the idea of wrong database. This makes some sense as I
> am having great difficulty with pg_dump, with somewhat similar error
> messages.
PGAdmin connects to the "postgres" database by default, which is created
automatically at install time. To create a table in a different
database, you click on the correct database in the treeview on the left
then right-click and select "New...", or use the "New" button at the top
of the screen. Are you inadvertently creating the tables in the
"postgres" database?
When you use pg_dump, you need to specify the database by means of the
-d switch.
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
---------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | R. Kevin Bean | 2007-07-31 19:53:20 | Problem with Query Tool F5 |
Previous Message | Luca Ferrari | 2007-07-31 16:12:53 | Re: PG Admin |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2007-07-31 17:19:06 | Re: plperl syntax highlighting for vi |
Previous Message | jo | 2007-07-31 16:26:02 | date ranges |