primary key and indexing - Mailing list pgsql-sql

From Sharmad Naik
Subject primary key and indexing
Date
Msg-id 001201c081f9$87ebef00$1a090b3d@SharmadNaik
Whole thread Raw
List pgsql-sql
I m sorry If anyone has already asked this Q earlier
    I wanted to know
 
Q1. Whether I can have another key on which the table is indexed even though i have a primary key..Then how would the data be accessed according to primary key or the indexed key of my choice or i can index as per my choice ( primary / index key)?
 
Q2. If possible can anybody tell me how to get the script given in the e-book of Postresql be interpreted in Perl i.e
perl <name of file>
gives an error that Pg is not connected to Dbase

pgsql-sql by date:

Previous
From: Poet/Joshua Drake
Date:
Subject: Re: PostgreSQL HOWTO
Next
From: "Nikolaj Lundsgaard"
Date:
Subject: Indices