Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 0768D9FB55F for ; Mon, 18 Jun 2007 23:41:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 16691-04 for ; Mon, 18 Jun 2007 23:41:24 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web63713.mail.re1.yahoo.com (web63713.mail.re1.yahoo.com [69.147.97.98]) by postgresql.org (Postfix) with SMTP id 2BF0F9FB55A for ; Mon, 18 Jun 2007 23:41:25 -0300 (ADT) Received: (qmail 98824 invoked by uid 60001); 19 Jun 2007 02:41:23 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=h26A/5XRN8ScAGAv40yX155qyVV0G2Y0VtQFYYprTsZ9T2T51Y3SPgPa9LvIj1rfy0KjRgYvkS2m2ZkYba6fihG6GLfa+s828OJDpAY/BAkF+QWejFZM5rwfliTw/MY0psCFZFCjHAuTq4gtp2p50yO6PZCrPT/NC7O80rwPUYI=; X-YMail-OSG: ND6ppMMVM1kP85qnZF1BNRXjjeKddJjJOlUGRpV_oW3T0KawLgQ81QZPZ.ea9lYvW6oeL9CeB.QrtbtrdN4UiSLd2QdFcrFRWwjv92qgFmT22bRLSlAI6C2X25qmE3E- Received: from [190.64.227.159] by web63713.mail.re1.yahoo.com via HTTP; Mon, 18 Jun 2007 21:41:23 CDT Date: Mon, 18 Jun 2007 21:41:23 -0500 (CDT) From: Gabriel Hermes Colina Zambra Subject: Re: Ejecutar \copy desde VB To: Jaime Casanova , Chapilliquen Gutierrez Eduardo Cc: Alvaro Herrera , pgsql-es-ayuda@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <570797.97455.qm@web63713.mail.re1.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.098 tagged_above=0 required=5 tests=AWL=-0.258, BAYES_50=0.001, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447 X-Spam-Level: *** X-Archive-Number: 200706/414 X-Sequence-Number: 28246 --- Jaime Casanova escribió: > On 6/18/07, Chapilliquen Gutierrez Eduardo > wrote: > > Pero como puedo cargar mi archivo con COPY FROM > STDIN?? > > > > ejecutas el comando "COPY tutabla FROM stdin;" con > conexion.execute > > y luego empiezas a enviar datos a traves de STDIN, > este articulo > muestra como hacerlo > http://support.microsoft.com/kb/239588 > > Bueno... te da una idea, para que puedas seguir > adelante ;) > > -- > Atentamente, > Jaime Casanova > > "Programming today is a race between software > engineers striving to > build bigger and better idiot-proof programs and the > universe trying > to produce bigger and better idiots. > So far, the universe is winning." > Richard Cook > -- > ---------------------------(fin del > mensaje)--------------------------- > TIP 5: ¿Has leído nuestro extenso FAQ? > > http://www.postgresql.org/files/documentation/faqs/FAQ.html > Otra burda manera pero menos complicada, es crear un .bat que maneje set pgpassword=clavedeusuariopostgres y ejecutar el bat con la instruccion shell desde visual basic, quiza teniendo un lnk apuntando al bat. Es una idea burda pero funciona. Atte. Gabriel Hermes Colina Zambra __________________________________________________ Correo Yahoo! Espacio para todos tus mensajes, antivirus y antispam ¡gratis! Regístrate ya - http://correo.espanol.yahoo.com/