Re: Database - Table browing problem.

Hi Dave,

It worked. But why is there a difference between the interfaces?? Is it
because of the use of capital letters in the definition of the table names??
Is it a standard behavier or pgSQL/pgAdmin limitation??

Here is another doubt. When the table is created from the psql console, its
not pssible to see its proerties in the pgAdmin interface. However I can see
the table details e.g. columns, checks, FKs etc. The error message says:

An error has occured in pgAdminII:frmMain.tvTable
Number: 2147467259
Error:person: permission denied.

-anil.


> > -----Original Message-----
> > From: Anil Jangam [mailto:anilj@indts.com] 
> > Sent: 14 December 2001 09:41
> > To: 'pgsql-cygwin@postgresql.org'
> > Subject: [CYGWIN] Database - Table browing problem.
> > Importance: High
> > 
> > 
> > Hi,
> > 
> > I have successfully created a user (createuser command) and 
> > the database (using createdb command). Now when I create a 
> > table either by using the create table commnd or through 
> > pgAdmin interface, its creating the table succesfully.. but 
> > when I try to see the contents of the table i.e. select * 
> > from ; it gives the error message, 
> > 
> > 		"ERROR:  Relation '' does not exist
> > 
> > What could be the problem?? I couldn't resolve it.
> 
> pgAdmin will allow you to create a table with capital letters 
> in the name.
> If you have done this, then make sure you surround the name 
> in quotes in
> your select query e.g.
> 
> SELECT * FROM "MixedCaseName"
> 
> Regards, Dave
>