zhaoxin wrote:
> I have to face this trouble , it is not I want , but a historical problem .
> so , can you tell me ?
Sure, but you'll need to say what column-types you have.
Below is a small script to generate a table with lots of columns.
#!/bin/perl -w
use strict;
my $tbl = 'test_text';
my $typ = 'text';
my $num_cols = 1500;
print "CREATE TABLE $tbl (\n";
for (my $c=0; $c<$num_cols; $c++) {
print " col$c $typ,\n";
}
print "PRIMARY KEY (col0)\n";
print ");\n";
exit;
You can run it with something like:
perl mk_script.pl | psql -Urichardh richardh
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
