Skip site navigation (1) Skip section navigation (2)

Re: check CREATE/DROP INDEX

From: Volkan YAZICI <volkan(dot)yazici(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: check CREATE/DROP INDEX
Date: 2005-04-28 19:56:41
Message-ID: 7104a73705042812564f163557@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

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);
=> \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.

In response to

pgsql-novice by date

Next:From: Michael FuhrDate: 2005-04-29 05:00:19
Subject: Re: function in a view
Previous:From: Keith WorthingtonDate: 2005-04-28 18:58:53
Subject: function in a view

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group