From: Thurstan R. McDougle <trmcdougle@my-deja.com>
To: pgsql-sql@postgresql.org
Subject: Re: table restruct...
Date: Thu, 20 Sep 2001 16:23:01 +0100
Message-ID: <3BAA09D5.F6ED354A@my-deja.com> (raw)
References: <3BA9FDB8.109C1A5@dkfz-heidelberg.de>
"David M. Richter" wrote:
>
snip...
> 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?
Look at the entry for the CLUSTER command at
http://www.postgresql.org/idocs/index.php?sql-cluster.html> Is the order of a database under all circumstances the same? (in pg)
Normally the primary key or an ORDER BY on the SELECT force this
according to the use the specific search is for.
>
> That is essential for my further restruction of the database...
Changing columns is no unheard of, but changing row order is only
normally done for performance reasons... Could you say why you need
this, we suspect you do not in fact NEED it!
>
> Thanks a lot
>
> David
--
This is the identity that I use for NewsGroups. Email to
this will just sit there. If you wish to email me replace
the domain with knightpiesold . co . uk (no spaces).
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: trmcdougle@my-deja.com
Subject: Re: table restruct...
In-Reply-To: <3BAA09D5.F6ED354A@my-deja.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox