Skip site navigation (1) Skip section navigation (2)

Re: [NOVICE] How to split a table?

From: "Felix Zhang" <felix(dot)zhang(dot)2005(at)gmail(dot)com>
To: "Andreas Kretschmer" <akretschmer(at)spamfence(dot)net>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] How to split a table?
Date: 2006-10-17 09:07:25
Message-ID: c44bd2680610170207y547f5641p4120e7a2b7ecdfd1@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novicepgsql-sql
to do some statistics analysis.

2006/10/17, Andreas Kretschmer <akretschmer(at)spamfence(dot)net>:
>
> Felix Zhang <felix(dot)zhang(dot)2005(at)gmail(dot)com> schrieb:
>
> > Hi,
> >
> > I want to split a table to 2 small tables. The 1st one contains 60%
> records
> > which are randomly selected from the source table.
> > How to do it?
>
> Why do you want to do this?
>
>
> Andreas
> --
> Really, I'm not out to destroy Microsoft. That will just be a completely
> unintentional side effect.                              (Linus Torvalds)
> "If I was god, I would recompile penguin with --enable-fly."    (unknow)
> Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org
>

In response to

pgsql-novice by date

Next:From: Achilleas MantziosDate: 2006-10-17 09:09:59
Subject: Re: [GENERAL] How to split a table?
Previous:From: Gregory S. WilliamsonDate: 2006-10-17 08:53:35
Subject: Re: [SQL] How to split a table?

pgsql-general by date

Next:From: Achilleas MantziosDate: 2006-10-17 09:09:59
Subject: Re: [GENERAL] How to split a table?
Previous:From: Gregory S. WilliamsonDate: 2006-10-17 08:53:35
Subject: Re: [SQL] How to split a table?

pgsql-sql by date

Next:From: Achilleas MantziosDate: 2006-10-17 09:09:59
Subject: Re: [GENERAL] How to split a table?
Previous:From: Gregory S. WilliamsonDate: 2006-10-17 08:53:35
Subject: Re: [SQL] How to split a table?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group