Thread: check CREATE/DROP INDEX

check CREATE/DROP INDEX

From
tövis
Date:
I'm using PostgreSQL 7.4.6-5 and pgAdmin III. Version 1.2.0
Created tables, constraint, sequencies are seen well on pgAdmin, but I can not see any of my INDEX -es!? How can I check them, they are really exists or something is wrong? Documentation talk about "default table space"? I thought that as the superuser from pgAdmin I should have see everything, is not it?
 

Re: check CREATE/DROP INDEX

From
Volkan YAZICI
Date:
Hi,

On 4/28/05, tövis <tovises@freemail.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);
=> \d
$ pgadmin3
# 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
=> \di
-- There should exist your index in the appeared list.