I have a little problem : I'm working with a postgresql database with oobase using the postgres connector. I've noticed that it was possible to save data in csv by copy/paste table/views in oocalc, which is a very good thing.
Unfortunately, there is a view I'd like to export, but which causes problems : it's a result of a join of several subqueries, and when pasting in oocalc, some column names are not et the right place.
To be more explicit, here is what my view definition looks like :
Code: Select all
SELECT t.id,t.a,t.b,t.c,t.d,t.e,temp1.x as r1,temp2.x as r2, ... , temp60.x as r60
from t, ( SELECT id,x from t2 where y=1) as temp1, ( SELECT id,x from t2 where y=2) as temp2, ( SELECT id,x from t2 where y=3) as temp3, ...
WHERE t.id=temp1.id,t.id=temp2.id, ... , t.id=temp60.id;
|
|
Independantly of the column names, the data in the columns are not affected by this, and so the column name doesn't match anymore the column contains.
Does anybody has this problem before ?
Thanks
Alexis