Re: [GENERAL] About Maximum number of columns

2005-12-22 Thread Bruce Momjian
Scott Marlowe wrote: > On Thu, 2005-12-22 at 10:10, Jim C. Nasby wrote: > > On Thu, Dec 22, 2005 at 07:22:12PM +0800, zhaoxin wrote: > > > Hi All. > > > > > > I have a question about the Maximum number of columns in a table ? > > > > > > In FAQ for PostgreSQL,I can find this description : > > >

Re: [GENERAL] About Maximum number of columns

2005-12-22 Thread Scott Marlowe
On Thu, 2005-12-22 at 10:10, Jim C. Nasby wrote: > On Thu, Dec 22, 2005 at 07:22:12PM +0800, zhaoxin wrote: > > Hi All. > > > > I have a question about the Maximum number of columns in a table ? > > > > In FAQ for PostgreSQL,I can find this description : > > Maximum number of columns in a table

Re: [GENERAL] About Maximum number of columns

2005-12-22 Thread Jim C. Nasby
On Thu, Dec 22, 2005 at 07:22:12PM +0800, zhaoxin wrote: > Hi All. > > I have a question about the Maximum number of columns in a table ? > > In FAQ for PostgreSQL,I can find this description : > Maximum number of columns in a table? > 250-1600 depending on column types > But , I want

Re: [GENERAL] About Maximum number of columns

2005-12-22 Thread Richard Huxton
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 $

Re: [GENERAL] About Maximum number of columns

2005-12-22 Thread Tino Wildenhain
zhaoxin schrieb: > I have to face this trouble , it is not I want , but a historical problem . > so , can you tell me ? Try it out. I'd change the future of that history though. You can expect much better performany on virtually any RDBMS with appropriate schema. ++Tino PS: try to send text-onl

Re: [GENERAL] About Maximum number of columns

2005-12-22 Thread zhaoxin
I have to face this trouble , it is not I want , but a historical problem . so , can you tell me ? Richard Huxton wrote: > zhaoxin wrote: > >>Hi All. >> >>I have a question about the Maximum number of columns in a table ? >> >>In FAQ for PostgreSQL,I can find this description : >> Maximum numbe

Re: [GENERAL] About Maximum number of columns

2005-12-22 Thread Richard Huxton
zhaoxin wrote: > Hi All. > > I have a question about the Maximum number of columns in a table ? > > In FAQ for PostgreSQL,I can find this description : > Maximum number of columns in a table? > 250-1600 depending on column types > But , I want to know what type is 1600 limit , and wha