Postgres SQL Syntax

Поиск
Список
Период
Сортировка
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?

В списке pgsql-general по дате отправления: