Re: Database - Table browing problem.

> -----Original Message-----
> From: Anil Jangam [mailto:anilj(at)indts(dot)com]
> Sent: 14 December 2001 10:51
> To: 'Dave Page'; Anil Jangam; 'pgsql-cygwin(at)postgresql(dot)org'
> Subject: RE: [CYGWIN] 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??

There isn't a difference between the interfaces, it's just that pgAdmin
automatically adds the quotes to object names, whereas in psql you must type
them yourself.

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

Are you running pgAdmin as the postgresql superuser?

>
> -anil.
>
>
> > > -----Original Message-----
> > > From: Anil Jangam [mailto:anilj(at)indts(dot)com]
> > > Sent: 14 December 2001 09:41
> > > To: 'pgsql-cygwin(at)postgresql(dot)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
> >
>