[SQL] Problems importing data

2004-08-20 Thread Devin Whalen
e a lot of data. Any suggestions would be appreciated. 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

Re: [SQL] Sending errors from psql to error file

2004-08-12 Thread Devin Whalen
On Thu, 2004-08-12 at 11:09, Oliver Elphick wrote: > On Thu, 2004-08-12 at 16:01, Devin Whalen wrote: > > > zcat cli_postDataInserts.sql.gz | > > >psql -d cli_post -U system --echo-queries -f - >trace.file 2>&1 > > > > Just a few questions a

Re: [SQL] Sending errors from psql to error file

2004-08-12 Thread Devin Whalen
On Thu, 2004-08-12 at 10:50, Oliver Elphick wrote: > On Thu, 2004-08-12 at 15:20, Devin Whalen wrote: > > Hello, > > > > I am trying to migrate a client from one database to another. Basically > > we designed a web application for them using Postgresql but we have m

[SQL] Sending errors from psql to error file

2004-08-12 Thread Devin Whalen
plete. 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

Re: [SQL] Converting a plperlu function to a plpgsql function

2004-07-22 Thread Devin Whalen
On Thu, 2004-07-22 at 15:09, Jeff Eckermann wrote: > --- Joe Conway <[EMAIL PROTECTED]> wrote: > > Devin Whalen wrote: > > > First line: > > > my @active_tables=split(/,/,$tables); > > > > > > Is there anyway to split a variable like the perl >

[SQL] Converting a plperlu function to a plpgsql function

2004-07-22 Thread Devin Whalen
. Now you 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