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,
[EMAIL PROTECTED]
The Computing Froggy
----- Message d'origine ----
De : David BOCCOU <[EMAIL PROTECTED]>
À : pgadmin-support@postgresql.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
