Hi,
I'm using postgresql 9 and I'd like to know if there is a way to "ask" if
when I'm going to add a column, I'm exceeding the max number of columns.
I've found that the max number of columns is 1600 and It's depends of the
data types.
I've made a test adding 1600 columns using different data ty
Unfortunately It's an inherited data model and I can't make any change for
now...
Thanks for your answer!
On Tue, Jul 12, 2011 at 2:52 PM, Reinoud van Leeuwen <
reinou...@n.leeuwen.net> wrote:
> On Tue, Jul 12, 2011 at 02:48:26PM -0300, Miguel Angel Conte wrote:
>
> >
>
> Hi Ken,
>
> Do you know a good way to get the max row size in a table?
> Or maybe I'll have to get this information from the metadata
>
> thanks!
>
>
> On Tue, Jul 12, 2011 at 3:11 PM, k...@rice.edu wrote:
>
>> On Tue, Jul 12, 2011 a
Yes, sure. I mean, I can't change the whole process which creates columns
dynamically.
On Tue, Jul 12, 2011 at 6:12 PM, Reinoud van Leeuwen <
reinou...@n.leeuwen.net> wrote:
> On Tue, Jul 12, 2011 at 03:08:36PM -0300, Miguel Angel Conte wrote:
> > Unfortunately It's an i
more
> > informed. I would make damn sure you notify the stakeholders in this
> > project that the data model is screwed and needs a redesign. I agree
> > that you should split this table and do a join if you have no option
> > of redesigning this.
> >
> >
s the
most efficient solution.
On Wed, Jul 13, 2011 at 1:51 PM, Scott Marlowe wrote:
> On Wed, Jul 13, 2011 at 9:45 AM, Miguel Angel Conte
> wrote:
> > Hi,
> > Thanks for your interest. This app load scv files which change every day
> > (sometimes the columns too). The sizes of th
I have the metadata in the same csv.
On Wed, Jul 13, 2011 at 3:00 PM, Kevin Crain wrote:
> How are you determining the data types for these columns?
>
> On Wed, Jul 13, 2011 at 8:45 AM, Miguel Angel Conte
> wrote:
> > Hi,
> > Thanks for your interest. This app load scv
