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

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novicepgsql-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

pgsql-novice by date

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

pgsql-general by date

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

pgsql-sql by date

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

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