Hi,

Thanks to your attention and time!

Now I have a table, say sampleTable, on which I would automatically (using
shell script like stuff) split it into several small tables according to the
first attribute.

Suppose the first attribute, A, has 100 possible values, say, a1, a2, ...,
a100, then the desired set of tables are table_1, table_2, ..., table_100,
where table_i contains all the tuples whose A is a_i.

Manually, I know that the following simple SELECT could generate the content
for table_i, (create table table_i select * from sampleTable where A = a1).
But I am not sure how to automated this process to generate all the 100
tables.

thanks,

Chao