On Saturday 30 March 2002 15:53, Vijay Deval wrote: > I am a latecomer into this thread. Some points that occured to me are > as follows: > > 1)In xls each cell can have independent defination. .xls data can be > imported into any database, only if all cells in a column are of the > same type.
That's true. My concern is multiple sheets. Excel is going to dump multiple sheets one after another in a single text file. Certainly postgres can not accept such input for copy. It must be raw data for copy. > 2)A computed column need not be imported as "data". It can be generated > in postgres. Agreed. ut computed values are of real use. So we can put them in database stright away. And as far as making sure that formula generated proper values in postgres, we need to write additional triggers/functions for that. > Are these points valid? Certainly. Shridhar _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help
