On 17/03/2009 15:28, Ivano Luberti wrote:
> I'm sorry, you are right that is the problem
> I had interpreted that as the file should reside on the same machine
> where pgAdmin (or another client) runs , not the server.
>
> Thank you again
You're welcome! That actually cost me a half-hour or so of
I'm sorry, you are right that is the problem
I had interpreted that as the file should reside on the same machine
where pgAdmin (or another client) runs , not the server.
Thank you again
Raymond O'Donnell ha scritto:
> On 17/03/2009 15:04, Ivano Luberti wrote:
>
>> Thanks but it keeps on not
On 17/03/2009 15:04, Ivano Luberti wrote:
> Thanks but it keeps on not finding the file: the warning has disappeared
>
>
> ERROR: could not open file "c:\temp\anagraficaANIDIs.csv" for reading:
> No such file or directory
You haven't said whether the file is on the same machine as the server -
Thanks but it keeps on not finding the file: the warning has disappeared
ERROR: could not open file "c:\temp\anagraficaANIDIs.csv" for reading:
No such file or directory
** Errore **
ERROR: could not open file "c:\temp\anagraficaANIDIs.csv" for reading:
No such file or director
On 17/03/2009 14:45, Ivano Luberti wrote:
> Hi all, executing the following command inside pgAdmin on my Windows
> Vista (please avoid comment, I pray you) :
>
> copy anagrafica_import from 'c:\\temp\\anagraficaANIDIs.csv' WITH CSV
Try putting an 'E' in front of the path, like this:
from E
Hi all, executing the following command inside pgAdmin on my Windows
Vista (please avoid comment, I pray you) :
copy anagrafica_import from 'c:\\temp\\anagraficaANIDIs.csv' WITH CSV
I get the following error:
WARNING: nonstandard use of \\ in a string literal
LINE 1: copy anagrafica_import fro
ches ?
Also does COPY treat timestamp & LOBs data different?
Thanks
Sharmila
--- On Thu, 2/12/09, Scott Marlowe wrote:
From: Scott Marlowe
Subject: Re: [GENERAL] COPy command question
To: sharmi...@yahoo.com
Cc: "General postgres mailing list"
Date: Thursday, February 12, 2009, 1:3
On Wed, Feb 11, 2009 at 11:22 AM, SHARMILA JOTHIRAJAH
wrote:
> Hi,
> A question about the Postgresql's COPY command.
>
> This is the syntax of this command from the manual
>
> COPY tablename [ ( column [, ...] ) ]
> FROM { 'filename' | STDIN }
> [ [ WITH ]
> .
> I want to migr
Yes should work perfectly as suggested by Sam,
chk this for jdbc support:
http://kato.iki.fi/sw/db/postgresql/jdbc/copy/
Sam Mason wrote:
On Wed, Feb 11, 2009 at 10:22:23AM -0800, Sharmila Jothirajah wrote:
I want to migrate my tables from Oracle to Postgres.
The COPY FROM command can tak
On Wed, Feb 11, 2009 at 10:22:23AM -0800, Sharmila Jothirajah wrote:
> I want to migrate my tables from Oracle to Postgres.
> The COPY FROM command can take input from 'file' or 'STDIN'.
> Is it possible for the COPY command to take its input from a
> java program(which contains the oracle results
Hi,
A question about the Postgresql's COPY command.
This is the syntax of this command from the manual
COPY tablename [ ( column [, ...] ) ]
FROM { 'filename' | STDIN }
[ [ WITH ]
.
I want to migrate my tables from Oracle to Postgres.
The COPY FROM command can take input fro
11 matches
Mail list logo
