Re: [GENERAL] How to change the file encoding of a 3gb file?

2010-07-18 Thread manitou-sig
Andre Lopes wrote: > I'am trying to import an SQL file with 3gb of INSERTS. I must to change the > encode of the file to UTF8, how can I change the encode of the file without > open it? This 3gb file crashes every program... > > Give me a clue. I'd use recode: http://recode.progiciels-b

Re: [GENERAL] passing parameters to multiple statements

2009-11-16 Thread manitou-sig
Konstantin Izmailov wrote: > I'm planning to use multiple statements via libpq. Before starting coding > I'm trying to understand are there any limitations on passing parameters. > E.g. would the following work: > PQexecParams(conn, "BEGIN;INSERT INTO tbl VALUES($1,$2);SELECT > lastval()