Postgres SQL Syntax
| От | Jim C. |
|---|---|
| Тема | Postgres SQL Syntax |
| Дата | |
| Msg-id | epu2jq$vl8$1@sea.gmane.org обсуждение |
| Ответы |
Re: Postgres SQL Syntax
Re: Postgres SQL Syntax Re: Postgres SQL Syntax |
| Список | pgsql-general |
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 по дате отправления: