[GENERAL] Converting mysql "on update" to postgres "rule"

Thanks to everyone who's helped me before. I'm trying to create the following mysql table in postgres: CREATE TABLE visit ( data1 varchar(30) NOT NULL, data2 varchar(30) DEFAULT NULL, data3 timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP); Thus far, I've b

[GENERAL] MySQL to Postgres question

The table I have in MySQL is similar to below: 0 SET FOREIGN_KEY_CHECKS=0; 1 CREATE TABLE products ( 2 product_id integer(11) not null auto_increment, 3 product_name varchar(255) not null, 4 product_descrition varchar(255) not null, 5 class_id integer(11) not null, 6 sub

[GENERAL] MySQL to Postgres question

The table I have in MySQL is similar to below: 0 SET FOREIGN_KEY_CHECKS=0; 1 CREATE TABLE products ( 2 product_id integer(11) not null auto_increment, 3 product_name varchar(255) not null, 4 product_descrition varchar(255) not null, 5 class_id integer(11) not null, 6 sub