From: kohlit@icqmail.com
Date: Thu 14 Jul 2005 - 14:14:03 EEST
merhaba;
ben listedekilerden ornekli bi anlatim istemedim. ornekli bi anlatimi
olan makalenin linkini istedim.
peki soyle anlatiyim:
tablomu olusturmak icin:
create table musteri(
alan1 integer,
alan2 varchar(200) not null,
alan3 varchar(200) not null );
buda csv dosyamin icerigi:
1;SMS Inventory Agent;1
2;SNMP Trap Receiver;0
3;Audited Software;0
4;Outside Vendor;0
5;SMS Opal Conversion Process;1
6;SMS_WINNT_SERVER_DISCOVERY_AGENT;1
7;SMS_NT_USER_DISCOVERY_AGENT;1
8;SMS_AD_USER_DISCOVERY_AGENT;1
9;SMS_NT_USER_GROUP_DISCOVERY_AGENT;1
10;SMS_AD_SYSTEM_DISCOVERY_AGENT;1
11;SMS_AD_SYSTEM_GROUP_DISCOVERY_AGENT;1
copy musteri from '/veri3.csv' with CSV; komutunu verince asagidaki
hatayi veriyor. neden, nicin??
ERROR: invalid input syntax for integer: "1;SMS Inventory Agent;1"
CONTEXT: COPY musteri, line 1, column alan1: "1;SMS Inventory Agent;1"
//Ailenizin web sayfası olan gunduz.org'daki belgelerin birinde bununla
//ilgili ayrıntılar var:
//ALTER USER postgres WITH ENCRYPTED PASSWORD 'sifre';
evet onu okumustum gorunce hatirladim.
saygilar.
<P><font face="Arial, Helvetica, sans-serif" size="2" style="font-size:13.5px">_______________________________________________________________<BR><font face="Arial, Helvetica, sans-serif" size="2" style="font-size:13.5px">ICQ - You get the message, anywhere!<br>Get it @ http://www.icq.com</font><br><br> </font></font>
_______________________________________________
Linux-programlama mailing list
Linux-programlama@liste.linux.org.tr
http://liste.linux.org.tr/mailman/listinfo/linux-programlama