Re: table restruct... - Mailing list pgsql-sql

From David M. Richter
Subject Re: table restruct...
Date
Msg-id 3BA9FDB8.109C1A5@dkfz-heidelberg.de
Whole thread Raw
In response to Re: table restruct...  (Kovacs Baldvin <kb136@hszk.bme.hu>)
Responses Re: table restruct...
List pgsql-sql
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
Attachment

pgsql-sql by date:

Previous
From: Patrik Kudo
Date:
Subject: Re: Selecting latest value
Next
From: Haller Christoph
Date:
Subject: Re: Selecting latest value II