[SQL] Problems importing data

. Later -- Devin Whalen Programmer Synaptic Vision Inc Phone-(416) 539-0801 Fax- (416) 539-8280 1179A King St. West Toronto, Ontario Suite 309 M6K 3C5 Home-(416) 653-3982 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL

[SQL] Sending errors from psql to error file

. I tried this command but it didn't work: gunzip -c cli_postDataInserts.sql.gz | psql cli_post -U system | grep ERROR:* import_errors Any help is appreciated. Thanks. -- Devin Whalen Programmer Synaptic Vision Inc Phone-(416) 539-0801 Fax- (416) 539-8280 1179A King St. West Toronto, Ontario

[SQL] Converting a plperlu function to a plpgsql function

may be saying that why don't I just leave it in perl? Well, I would like to but my boss wants me to convert this to PL/pgSQLlong story. Anyway, if it can't be done it can't be done. But I was just wondering if anyone has any advice. Thanks for the help. Later -- Devin Whalen