Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id A95F847660F for ; Thu, 2 May 2002 11:52:56 -0400 (EDT) Received: from VL-MS-MR003.sc1.videotron.ca (relais.videotron.ca [24.201.245.36]) by postgresql.org (Postfix) with ESMTP id 1CF16476347 for ; Thu, 2 May 2002 11:24:22 -0400 (EDT) Received: from pippo.videotron.ca ([24.203.142.29]) by VL-MS-MR003.sc1.videotron.ca (Netscape Messaging Server 4.15 MR003 Jul 24 2001 16:23:26) with ESMTP id GVHPGP01.ACJ for ; Thu, 2 May 2002 11:24:25 -0400 Message-Id: <5.1.0.14.2.20020502111644.00a8f3b8@mail.host45.com> X-Sender: vltazczw@pop.videotron.ca X-Mailer: QUALCOMM Windows Eudora Version 5.1 Date: Thu, 02 May 2002 11:24:24 -0400 To: pgsql-php@postgresql.org From: "P. Jourdan" Subject: column insert Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200205/10 X-Sequence-Number: 1142 I have to insert 2 columns into an existing database that seems to be altered after a restore. I do not know what datatype should be entered for "path" and for "referer". The others are int4 and timestamptz for when_stamp. Here is the code: /* * Statistics: write page view */ if($loglevel>=1) { sqlquery(" insert into visits (session_id,page_id,when_stamp,path,referer) select session_id,$page_id,'now','$REQUEST_URI','$HTTP_REFERER' from session where hash='$sid'"); } Thanks for any help. Phil Jourdan