Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8KAXde91233 for ; Thu, 20 Sep 2001 06:33:40 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f8KAVIT21683 for pgsql-sql@postgresql.org; Thu, 20 Sep 2001 06:31:18 -0400 (EDT) (envelope-from news) From: "David M. Richter" X-Newsgroups: comp.databases.postgresql.sql Subject: table restruction Date: Thu, 20 Sep 2001 12:34:08 +0200 Organization: German Cancer Research Center Lines: 70 Message-ID: <3BA9C620.4164B047@dkfz-heidelberg.de> Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="------------5C3B0D18DDA6E75415107CBB" X-Complaints-To: scrappy@hub.org X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.16 i686) X-Accept-Language: en To: pgsql-sql@postgresql.org X-Archive-Number: 200109/168 X-Sequence-Number: 4848 This is a multi-part message in MIME format. --------------5C3B0D18DDA6E75415107CBB Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello! I want to restructure a table called study. this table has the following structure: Table "study" Attribute | Type | Modifier ------------------------+------------------------+---------- chilioid | character varying(80) | instanceuid | character varying(64) | id | character varying(64) | studydate | date | studytime | time | modality | character varying(2) | manufacturer | character varying(128) | referingphysician | character varying(128) | description | character varying(128) | manufacturersmodelname | character varying(128) | importtime | double precision | chilisenderid | character varying(80) | accessionnumber | character varying(64) | institutionname | character varying(128) | workflowstate | character varying(8) | flags | character varying(8) | performingphysician | character varying(128) | reportingphysician | character varying(128) | parentoid | character varying(80) | So , what I have to do is to move the column parentoid between chilioid and instanceoid. After that operation parentoid is the second column in the table study. Can I do any restructuring in the running database or should I dump the database and create a new changed schema and then put the data from the dump back? So this would spent a lot of time, otherwise it works sure. Is there any oppertunity to restructure the existing database without using a dump? Thanks in advance David --------------5C3B0D18DDA6E75415107CBB 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 --------------5C3B0D18DDA6E75415107CBB--