Re: [GENERAL] PG Admin

[Raymond O'Donnell <rod(at)iol(dot)ie>]

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