I've a postgres statement that reads:
CREATE TABLE "channel" (
"chanid" int NOT NULL default '0',
"channum" varchar(10) NOT NULL default '',
"freqid" varchar(10) default NULL,
"sourceid" int default NULL,
.
.
.
PRIMARY KEY ("chanid"),
KEY "channel_src" ("channum","sourceid")
);
Postgres is choking on the KEY statement at the end.
> ERROR: table "channel" does not exist
> ERROR: syntax error at or near "(" at character 886
What's the proper postgres syntax for a double key like this?
Where can I find good examples of postgres syntax?