Christopher wrote: > A general ability to be able to dump views as if they were tables would > be more broadly applicable methinks? > > Merlin Moncure wrote: > > I have a situation where I need to hack pg_dump not to dump columns with > > a particular name. If this is of interest to the community I can spend > > a little extra effort and work up a patch. I'd be curious to see if > > anyone else thinks this is worthwhile. > >
Yes, although that would not solve my particular problem. Since I don't want to dump a particular column that is present in all tables, using views would mean creating a lot of views for one purpose :(. Basically, I have a simulated oid which is superior to the provided oid in all ways except one, in that the oid allows you to keep it from dumping. Another example of a column you might not want to dump is passwords...although that's a fairly weak case. hmm, I might be out in the wilderness on this one. Merlin ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
