[SQL] Job opportunity

2004-11-08 Thread Kyle
Action Target has a job opening for a programmer proficient in PostgreSQL and Tcl/Tk. We are located in Provo, UT (home of Novell). If interested, please contact: [EMAIL PROTECTED] Thanks!! ---(end of broadcast)--- TIP 6: Have you searched our list

Re: [SQL] [GENERAL] how to use COPY within plperl

2004-11-08 Thread Marek Lewczuk
Goutam Paruchuri wrote: Why can you not use simple insert statements (sql insert). Copy is meant to transfer large amount of data from text files to databases and vice versa. "Insert" is much slower if there are many (hundreds, thousands) data to be inserted - and in my case there will be thousand

Re: [SQL] Hi

2004-11-08 Thread Steven Klassen
* vasundhar <[EMAIL PROTECTED]> [2004-11-06 22:45:36 -0800]: > Hi I am using REL on which only 7.3.2 PG only available and I want > to upgrade it to the latest and also integrate it with Perl but my > system is also not supporting the DBI any suggestions please My suggestion would be to determine

Re: [SQL] Scheduling Jobs In PostgreSQL

2004-11-08 Thread Kaare Rasmussen
> Is it possbile to schedule jobs in postgres? I believe that the correct answer would be: Yes, it is possible, but No you wouldn't want to do that. A scheduler for PostgreSQL colud be written in Perl, but a much better idea would to use cron or another external scheduler. -- Kaare Rasmussen

[SQL] how to use COPY within plperl

2004-11-08 Thread Marek Lewczuk
Hello, I need to use COPY (instead of INSERT) within plperl function. I know that COPY will work if data will be taken from file - however I need to use STDIN. I tried this: spi_exec_query("COPY sometable (field1, field2) FROM stdin;"."\n"."sometext"."\t"."sometext"."\n"."\.") But it didn't wor