Re: [SQL] Max column number.

2011-07-13 Thread Miguel Angel Conte
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. On Tue, Jul 12, 2011 at 4:29 PM, Miguel Angel Conte diaf...@gmail.com wrote

Re: [SQL] Max column number.

2011-07-13 Thread Miguel Angel Conte
I have the metadata in the same csv. On Wed, Jul 13, 2011 at 3:00 PM, Kevin Crain kevin.cra...@gmail.com wrote: How are you determining the data types for these columns? On Wed, Jul 13, 2011 at 8:45 AM, Miguel Angel Conte diaf...@gmail.com wrote: Hi, Thanks for your interest. This app

[SQL] Max column number.

2011-07-12 Thread Miguel Angel Conte
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

Re: [SQL] Max column number.

2011-07-12 Thread Miguel Angel Conte
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: Something like: If I'm

Re: [SQL] Max column number.

2011-07-12 Thread Miguel Angel Conte
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 k...@rice.edu wrote: On Tue, Jul 12, 2011 at 03:08:36PM -0300, Miguel Angel Conte wrote

Re: [SQL] Max column number.

2011-07-12 Thread Miguel Angel Conte
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 inherited data model and I