Use select nextval('sequence_name') to get the unique ID from the sequence,
then put it in both queries via a PHP variable.
----- Original Message -----
From: "Mike Judkins" <mmacie@earthlink.net>
To: <pgsql-general@postgresql.org>
Sent: Monday, October 08, 2001 10:31 PM
Subject: [GENERAL] kinda newbie - ish question
> hi all,
>
> Im trying to insert a record with a php script. I insert a NULL value
> to get my auto increment unique key to automatically populate as
> usual. Then I want to be able to insert another value in this same row
> which is a URL. This URL is basically a path plus a filename which I
> want to have the exact same name as the unique key that was just
> generated for the row. Is there a quick way is SQL to do this or will
> I have to handle it in my script?
>
> Thanks for helping!
>
> Mike
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>