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 [EMAIL PROTECTED] --------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
