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@iol.ie
---------------------------------------------------------------