pg with different sql?
От | pocm@rnl.ist.utl.pt (Paulo J. Matos) |
---|---|
Тема | pg with different sql? |
Дата | |
Msg-id | 87y9j1j4bj.fsf@localhost.localdomain обсуждение исходный текст |
Ответы |
Re: pg with different sql?
Re: pg with different sql? |
Список | pgsql-sql |
Hi all, I'm new to postgres and I'm doing a database project for a subject at college in postgres. I've studied databases using DataBases Management Systems by Ramakrishnan. I've done some create tables and at psql interactive prompt I've done: \i proj.sql (where proj.sql is the filename with the CREATE TABLEs) AFAIK, SQL is standard and should be the same for all DBMSs. For example: CREATE TABLE socio (id integer SERIAL PRIMARY KEY,nome varchar,alcunha string,data_filiacao date) CREATE TABLE paga_cota (ano integer,mes integer,valor integer,id integer,PRIMARY KEY(id,ano,mes),FOREIGN KEY(id) REFERENCES(socio)) After this I get an error around CREATE (of the 2nd table). I just can't imagine what it might be. I'd appreciate your help. TIA, My best regards, -- Paulo J. Matos : pocm(_at_)rnl.ist.utl.pt Instituto Superior Tecnico - Lisbon Software & Computer Engineering - A.I.- > http://www.rnl.ist.utl.pt/~pocm --- Yes, God had a deadline... So, He wroteit all in Lisp!
В списке pgsql-sql по дате отправления: