[SQL] examine the database

2001-06-28 Thread Ilan Fait
are testing PostgerSQL database     and I do not  know how to monitor/examine the database.     Thanks,     Ilan _ ILAN FAIT Tel: 972-9-9519133  Ex.247    iWeb Technologies Fax: 972-9-9519134    91 Medinat Ha'Yehud

[SQL]

2001-06-28 Thread Ilan Fait
PostgerSQL database     and I do not  know how to monitor/examine the database.     Thanks,     Ilan ___ ILAN FAIT Tel: 972-9-9519133  Ex.247    iWeb Technologies Fax: 972-9-9519134    91 Medinat Ha'Yehud

[SQL] Changing datatype of a column

2001-06-26 Thread Ilan Fait
?   Thanks, Ilan   _ ILAN FAIT Tel: 972-9-9519133  Ex.247    iWeb Technologies Fax: 972-9-9519134    91 Medinat Ha'Yehudim St. Herzliya 46120 IL mailto:[EMAIL PROT

[SQL] How to build a TRIGGER in POSTGERSQL

2001-06-20 Thread Ilan Fait
Title: How to build a TRIGGER in POSTGERSQL    Hi ,   I need some help in  building  trigger and information about sysdate (System date), any help will be appreciate.    1) I need to build a trigger that every time I insert into the table  one of the columns will  get +1 numb

[SQL] How to build a TRIGGER in POSTGERSQL

2001-06-18 Thread Ilan Fait
Title: How to build a TRIGGER in POSTGERSQL    Hi ,   I need some help in  building  trigger and information about sysdate (System date), any help will be appreciate.    1) I need to build a trigger that every time I insert into the table  one of the columns will  get +1 numb