yes, I was doing it on a living database... not good?
I was not using -a
this is structure dump of the employee table:
/* --------------------------------------------------------
phpPgAdmin 2.4-1 DB Dump
http://www.sourceforge.net/projects/phppgadmin/
Host: db.city-map.de:5432
Database : "kunden"
Table : "mitarbeiter"
2002-06-17 16:06:15
-------------------------------------------------------- */
CREATE TABLE "mitarbeiter" (
"miano" char(6),
"name" text,
"email" text,
"titel" text,
"telefon" text,
"pos" int4,
"benutzername" text,
"lastlogindate" date,
"lastlogintime" time,
"sprache" int4,
"prov1" int2,
"prov2" int2,
"region" char(4)
);
CREATE UNIQUE INDEX "mitarbeiter_miano_idx" ON "mitarbeiter" ("miano");
Mit freundlichem Gruß
Henrik Steffen
Geschäftsführer
top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com Tel. +49 4141 991230
mail: steffen@topconcepts.com Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline: +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------