PG Admin

On 31/07/2007 16:55, Bob Pawley wrote:

Can anyone tell me why a table developed through the PG Admin interface
isn't found by SQL when accessing it through the SQL interface??

Hi Bob,

No reason that I can think of....can you describe *IN DETAIL* the steps
you followed and the result?

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------

On 7/31/07, Bob Pawley <rjpawley@shaw.ca> wrote:

Can anyone tell me why a table developed through the PG Admin interface
isn't found by SQL when accessing it through the SQL interface??

Bob Pawley

likely issues:
in the wrong schema
in the wrong database
in the wrong host :-)

merlin

Bob Pawley wrote:

Can anyone tell me why a table developed through the PG Admin
interface isn't found by SQL when accessing it through the SQL interface??

Bob Pawley

1) Are you sure you are connecting to the same database?
2) What kind of SQL interface you are using?

Andrei.

On Tuesday 31 July 2007 Bob Pawley's cat, walking on the keyboard, wrote:

Can anyone tell me why a table developed through the PG Admin interface
isn't found by SQL when accessing it through the SQL interface??

Maybe it is a problem of case-sensitive names? Check in the table definition
of pgadmin is the table name is quoted (like in "myTable"). Nothing comes
into my head now.

Luca

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