pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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).



view thread (4+ messages)

Message-ID: <3BAA09D5.F6ED354A@my-deja.com>
Permalink:  ../3BAA09D5.F6ED354A@my-deja.com/
Also on:    postgresql.org/message-id/3BAA09D5.F6ED354A@my-deja.com

 · 

reply

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