On 4/28/05, tövis <tovises(at)freemail(dot)hu> wrote:
> I'm using PostgreSQL 7.4.6-5 and pgAdmin III. Version 1.2.0
I'm trying below examples using same pgAdmin III version.
> Created tables, constraint, sequencies are seen well on pgAdmin, but I can
> not see any of my INDEX -es!?
# As a normal database user, typing...
$ psql test
=> CREATE TABLE t1 (f1 varchar);
=> CREATE INDEX t1_f1_idx ON t1 (f1);
# Connecting to test as knt (knt is not a superuser)
# From the list on the left frame, selecting:
# Databases > "test" > public > Tables > "t1" > Indexes > "t1_f1_idx"
# It's working as expected.
> How can I check them, they are really exists
> or something is wrong?
So you could see your indexes by using psql as well?
$ psql mydb
-- There should exist your index in the appeared list.
In response to
pgsql-novice by date
|Next:||From: Michael Fuhr||Date: 2005-04-29 05:00:19|
|Subject: Re: function in a view|
|Previous:||From: Keith Worthington||Date: 2005-04-28 18:58:53|
|Subject: function in a view|