Entering data in serial column
От | Devrim GUNDUZ |
---|---|
Тема | Entering data in serial column |
Дата | |
Msg-id | Pine.LNX.4.33.0109291317590.7637-100000@oper.metu.edu.tr обсуждение исходный текст |
Ответ на | What is wrong? (Wei Weng <wweng@kencast.com>) |
Список | pgsql-sql |
Hi all, Let's say I have a table named "info" having the following fields: name char(40), surname char(40), address char(40), id serial Now, since id is a serial, while inserting data into info I write: INSERT INTO info (name,surname,address) VALUES ('$name','$surname', '#address'); Is there a shorter way of doing this? I mean, if I had 40 fields in this table, would I have to write all the fields? I mean, is there a syntax beginning like INSERT INTO info VALUES (.... ? Regards and best wishes, Love, respect,sharing,Linux and PostgreSQL -- Devrim GÜNDÜZ Web & System Administrator ---- Web ve Sistem Yoneticisi (www.oper.metu.edu.tr) devrim@oper.metu.edu.tr devrimg@tr.net Phone : +90-535-328-9594 (cellular) Phone : +90-312-295-9595 (work : 09:00/17:00 on weekdays+Saturday) Phone : +90-312-286-5906 (home) http://devrim.oper.metu.edu.tr ------------------------------------------------------------------
В списке pgsql-sql по дате отправления: