Someone want to tell me why the below CREATE INDEX fails?
I've tried everything I can think of, and can't get that INDEX to be
created :(
-- $Id: groups.psql,v 1.2 1997/08/14 20:05:08 shevett Exp $
-- postgresql 6.1
--
-- Host: localhost Database: pts
----------------------------------------------------------
--
-- Table structure for table 'groups'
--
CREATE TABLE groups (
id CHAR(10) NOT NULL,
detail CHAR(30)
) \g
CREATE INDEX groups_indx ON groups ( id ) \g
--
-- Dumping data for table 'groups'
--
INSERT INTO groups (id, detail) VALUES ('PTS','PTS Development')\g