How to split a table?

From: "Felix Zhang" <felix(dot)zhang(dot)2005(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: How to split a table?
Date: 2006-10-17 07:39:21
Message-ID: c44bd2680610170039j3342e874ue78bc71a701f76e0@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice pgsql-sql

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?

Regards,
Felix

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Felix Zhang 2006-10-17 07:50:44 Any documatation about porting from Oracle to PostgreSQL
Previous Message Peter 2006-10-17 07:27:17 help with sql query

Browse pgsql-novice by date

  From Date Subject
Next Message Felix Zhang 2006-10-17 07:50:44 Any documatation about porting from Oracle to PostgreSQL
Previous Message Michael Fuhr 2006-10-17 04:49:35 Re: Using host variables -- segmentation fault

Browse pgsql-sql by date

  From Date Subject
Next Message Felix Zhang 2006-10-17 07:50:44 Any documatation about porting from Oracle to PostgreSQL
Previous Message chrisj 2006-10-17 03:27:42 Re: Assigning a timestamp without timezone to a timestamp