richyen3@xxxxxxxxx <richyen3@xxxxxxxxx> schrieb: > Hi, I'm trying to create a dumpfile for a client. The data is gathered > from about 7 tables, and I need to output all the columns as the client > wishes. > > I figure the best way to this is to collect data from multiple tables > and putting them into a view, and using the client's desired names to > be the column headings of this view. Then, I'd dump the data from a > view, and it'll all be ready for delivery. > > The problem I run into is that when I dump from a view, I just get the > query that defined it in the first place. With 8.2, you can COPY a VIEW. At the moment, you can create a new table as select * from the view and take a dump from this table. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknow) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
