On 25/03/2015 14:30, ginkgo36 wrote: > @Gary > I'm working on big data, because of the demands of the job so I > export/import/update data on this table every day. > > I guess it's possible that each query would need all 417 columns but it > seems unlikely... --> Yes, not at all but 2/3 of 417 columns :) > > I need gather data into one table for consistency and easy for export and > import, it's ok if I split data to smaller tables, but when > export/import/update, i must excute query on alot of table. And this way > lead data to inconsistency if I forget update/export/import on 1 or more > table. It is terrible.
You could create a view specifically for export, which would gather together data from all the tables. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
