Entering data in serial column

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
------------------------------------------------------------------

In response to

Browse pgsql-sql by date

  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?