0

I have 34 tables, each one has 17,000 rows and 500 columns. I would like to merge them so I have in the end 17,000 rows and 17,000 columns. The rows are labeled with numbers (0:17000). The columns are (0:500) , (501:1000) , etc.

After merging the tables the column labels should be (0:17000).

Mido2009
  • 149
  • 2
  • 10
  • 5
    [What is the maximum number of columns in a PostgreSQL select query](https://stackoverflow.com/a/12612255/1995738) – klin Oct 04 '18 at 03:22
  • 4
    500 columns per table sounds like a very bad design. 17k column... Are you sure that you know what you are doing? – S-Man Oct 04 '18 at 03:22
  • 3
    This is a really terrible idea for a **relational** database, suggest you research "normalization" https://en.wikipedia.org/wiki/Third_normal_form – Paul Maxwell Oct 04 '18 at 03:29
  • Better use NoSQL Databases to this much of columns – PrathapG Oct 04 '18 at 03:54
  • You may consider reformatting your ending table as JSON or something else. Question: are these 500 columns (or 17000 columns) all the same data type? – Joe Love Oct 04 '18 at 15:02
  • Thanks guys for the feedback! I am definitely redesigning what I am working on. – Mido2009 Oct 04 '18 at 21:03

0 Answers0