How to INSERT empty line into SEQUENTIAL table from PHP

From: Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: How to INSERT empty line into SEQUENTIAL table from PHP
Date: 2008-06-16 06:33:27
Message-ID: 990632DA-983C-4F0E-B54F-4CEC104DB023@grid.unep.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

rahter dump question, I guess....

But I have a table with a sequential index field, into which I would
like to add from time to time another line (via webbrowser), which in
turn, stays first empty, before it's being filled in later (via
webbrowser).

Because the ID field is sequential and indexed, I can't use

INSERT INTO table_xx (ID, field2, field3, field4) VALUES ('', '', '',
'');

neither (skipping ID because it should be filled in automatically):

INSERT INTO table_xx (field2, field3, field4) VALUES ('', '', '');

How am I supposed to do it?

Thanks for any hints,

Stef

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2008-06-16 06:53:50 Re: How to INSERT empty line into SEQUENTIAL table from PHP
Previous Message John Tregea 2008-06-15 23:27:05 PostgreSQL and AMD?