Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 14CE5475CA9
	for <pgsql-sql@postgresql.org>; Wed, 16 Oct 2002 03:33:05 -0400 (EDT)
Received: from ipmuda.com.my (unknown [211.24.2.213])
	by postgresql.org (Postfix) with ESMTP id 43E24475FDD
	for <pgsql-sql@postgresql.org>; Wed, 16 Oct 2002 03:32:39 -0400 (EDT)
Received: from WorldClient [127.0.0.1] by ipmuda.com.my [192.168.1.17]
	with SMTP (MDaemon.v3.5.3.R)
	for <pgsql-sql@postgresql.org>; Wed, 16 Oct 2002 14:57:50 +0800
Date: Wed, 16 Oct 2002 14:57:50 +0800
From: "Nelson Yong" <nelsonyong@ipmuda.com.my>
To: pgsql-sql@postgresql.org
Subject: How to create secondary key!!
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
X-Mailer: WorldClient Standard 3.5.0e
X-MDRemoteIP: 127.0.0.1
X-Return-Path: nelsonyong@ipmuda.com.my
X-MDaemon-Deliver-To: pgsql-sql@postgresql.org
Message-Id: <20021016073239.43E24475FDD@postgresql.org>
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/230
X-Sequence-Number: 9947


good day,

i'm using pgAdmin II as the remote client, after importing the text file 
to postgresql database; i'm start trying to find the way to create the 
primary key and secondary key. unfortunely, under the pgAdmin II there 
aren't any tools to do that. However i managed to fine the way to create 
the primary key by using the index function but i still cannot create the 
secondary key in my database. please advise me!






Best Regards,

       /'"`\   
      ( - - )       
--oooO--(_)--Oooo---------------------------------------------------------
 
Nelson Yong
nelsonyong@ipmuda.com.my
THE BUILDING MATERIALS PEOPLE