From: | Devrim GUNDUZ <devrim(at)oper(dot)metu(dot)edu(dot)tr> |
---|---|
To: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Entering data in serial column |
Date: | 2001-09-29 10:23:58 |
Message-ID: | Pine.LNX.4.33.0109291317590.7637-100000@oper.metu.edu.tr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)oper(dot)metu(dot)edu(dot)tr
devrimg(at)tr(dot)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
------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | david | 2001-09-29 13:59:21 | Re: Entering data in serial column |
Previous Message | Stephan Szabo | 2001-09-29 06:19:21 | Re: What is wrong? |