Re: Database - Table browing problem. - Mailing list pgsql-cygwin

From Anil Jangam
Subject Re: Database - Table browing problem.
Date
Msg-id F73B646FCC01D5118F530002B32C337263B249@INDTS_FS
Whole thread Raw
In response to Database - Table browing problem.  (Anil Jangam <anilj@indts.com>)
List pgsql-cygwin
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
>

pgsql-cygwin by date:

Previous
From: Dave Page
Date:
Subject: Re: Database - Table browing problem.
Next
From: Dave Page
Date:
Subject: Re: Database - Table browing problem.