Re: [SQL] Help on some SQL command...

2000-08-17 Thread Guo Bin
Hi, You can specify a default value for the create_date column like: create_date timestamp default 'now' In the insert statement just ommit that field and you will get the default, as insert into test1 (id, name) values (1, 'xxx'); Regards, -- Guo Bin ---

Re: [SQL] lo_export and files permissions

2000-08-16 Thread Guo Bin
t the file to a directory writable by nobody. Regards, -- Guo Bin --- [EMAIL PROTECTED] wrote: > De: Mike Baroukh <[EMAIL PROTECTED]> > À: <[EMAIL PROTECTED]> > Objet: lo_export and files permissions > Date : lundi 14 août 2000 10:44 > > Hi everybody. > &