Re : import from csv

Hi David,

I have not seen any replied to that ... so here I go.

No, there's no other option than psql AFAIK when using the COPY order with the data in the same file (COPY ... FROM STDIN).
Dave explained before, that COPY uses the console and the PG Admin III edit tool is not a console app but a window app.

But if you use a file and that file is on your PG server you can use the syntax,
COPY my_table FROM '/home/me/data/my_file.csv' CSV;

That will work but you will need to have the file on the same machine as the Postgres Server (that's why I put a Unix file name but that will work on Windows too).

Have fun,
L(at)u
The Computing Froggy

----- Message d'origine ----
De : David BOCCOU <DBOCCOU(at)odaxys(dot)fr>
À : pgadmin-support(at)postgresql(dot)org
Envoyé le : Lundi, 2 Avril 2007, 12h47mn 58s
Objet : [pgadmin-support] import from csv

<!--

/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
span.EmailStyle17
{font-family:Arial;color:windowtext;}
span.EmailStyle18
{font-family:Arial;color:navy;}
_filtered {margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.Section1
{}
-->

Hi all

I’ve read that the ‘Copy’
command could not be used with pgAdmin III : is there an alternative way to
import data from a .csv file using pgAdmin, or is mandatory to use psql ?

Thank you for reading me

David

___________________________________________________________________________
Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions !
Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses
http://fr.answers.yahoo.com