Re: [SQL] data loading

--- Richard Huxton <[EMAIL PROTECTED]> wrote: > On Friday 09 January 2004 02:13, [EMAIL PROTECTED] > wrote: > > Hi, > > > > > > i try to load data from flat file (comma > delimiter format) into > > temporary table . i use COPY command as below: > > > > dwnc=# copy biosadm.custdo_temp > > dwnc-#

Re: [SQL] Adding a column to a VIEW which has dependent objects.

Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes: > How do people extend a parent view which has > lot of dependent views? > The parent view cannot be dropped because that will > require recreating a dozen of dependent views. You're out of luck, you'll have to drop and remake them all. In future we

[SQL] Adding a column to a VIEW which has dependent objects.

Dear PostgreSQL gurus, How do people extend a parent view which has lot of dependent views? The parent view cannot be dropped because that will require recreating a dozen of dependent views. Is there any workaround. Also is there an easy way of dumping the definitions of all the dependent views o