[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 work. Thanks in advance.

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

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--Linux, spil,--Tlf:3816 2582
Kaki Datatshirts, merchandize  Fax:3816 2501
Nordre Fasanvej 12 Åben 12.00-18.00Email: [EMAIL PROTECTED]
2000 FrederiksbergLørdag 12.00-16.00   Web:  www.suse.dk

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

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 why your system won't support DBI
and fix it.

-- 
Steven Klassen - Lead Programmer
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, (503) 667-4564

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html

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 thousands of inserts made by 
plperl. I can make a file with the data (and load using COPY), but it 
would be better to use copy from stdin.

Thanks
ML

---(end of broadcast)---
TIP 6: Have you searched our list archives?
  http://archives.postgresql.org

[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 archives?
  http://archives.postgresql.org