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 <table name>; it gives the error message,
> >
> >         "ERROR:  Relation '<table name>' 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
>