Received: from newmail.DKFZ-Heidelberg.DE (newmail.inet.dkfz-heidelberg.de [193.174.53.39]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8KESae85772 for ; Thu, 20 Sep 2001 10:28:36 -0400 (EDT) (envelope-from d.Richter@dkfz-heidelberg.de) Received: from perkeo.inet.dkfz-heidelberg.de (perkeo.inet.dkfz-heidelberg.de [193.174.61.66]) by newmail.DKFZ-Heidelberg.DE (8.9.3/8.9.3/DKFZ-8.9.3) with ESMTP id QAA08954; Thu, 20 Sep 2001 16:28:30 +0200 (MET DST) Received: from dkfz-heidelberg.de (hendesse.inet.dkfz-heidelberg.de [193.174.61.158]) by perkeo.inet.dkfz-heidelberg.de (980427.SGI.8.8.8/DKFZ-8.6.4) with ESMTP id QAA27262; Thu, 20 Sep 2001 16:29:01 +0200 (MDT) Message-ID: <3BA9FDB8.109C1A5@dkfz-heidelberg.de> Date: Thu, 20 Sep 2001 16:31:20 +0200 From: "David M. Richter" Organization: German Cancer Research Center X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.16 i686) X-Accept-Language: en MIME-Version: 1.0 To: Kovacs Baldvin CC: pgsql-sql@postgresql.org Subject: Re: table restruct... References: Content-Type: multipart/mixed; boundary="------------18E4A8229224FAE47EC181A4" X-Archive-Number: 200109/172 X-Sequence-Number: 4852 This is a multi-part message in MIME format. --------------18E4A8229224FAE47EC181A4 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi! Thanks, to You! Yes I have to do . Now I solved that problem with rename the original table study to _study then create the new right structured table study , Insert into study (chilioid,...,...) SELECT * FROM _study; Ok not elegant but it works. Another questions: Can I change the physical order of the rows in a database? Is the order of a database under all circumstances the same? (in pg) That is essential for my further restruction of the database... Thanks a lot David --------------18E4A8229224FAE47EC181A4 Content-Type: text/x-vcard; charset=us-ascii; name="d.Richter.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for David M. Richter Content-Disposition: attachment; filename="d.Richter.vcf" begin:vcard url;quoted-printable:http://mbi.DKFZ-Heidelberg.de/=0D=0A n:M. Richter;David x-mozilla-html:FALSE org:Deutsches Krebsforschungszentrum/German Cancer Research Center;Division Medizinische und Biologische Informatik version:2.1 email;internet:d.richter@dkfz-heidelberg.de adr;quoted-printable:;;Im Neuenheimer Feld 280 url: http://mbi.DKFZ-Heidelberg.de/=0D=0AD-69120 Heidelberg, Germany ;Heidelberg;Germany;; x-mozilla-cpt:;-17024 fn:David M. Richter end:vcard --------------18E4A8229224FAE47EC181A4--