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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice pgsql-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

Browse pgsql-general by date

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

Browse pgsql-novice by date

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

Browse pgsql-sql by date

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