Re: [HACKERS] feature request: pg_dump --view

[Stephen Frost]

* Andrew Dunstan ([EMAIL PROTECTED]) wrote:
> elein wrote:
> >>pg_dump -t  will work.
> >
> >Oh, you got me all worked up.  I was reading this as a way to
> >dump the CONTENTS of a view not the DEFINITION of a view.
> >I thought someone sneaked in pg_dump of a query in there.
> >
> >  
> 
> How would you load such a dump, since views are by default select-only?

Create the appropriate table definition, and then load it up?  Of
course, an option to have the pg_dump include the table definition
derived from the view would be nice also.

Thanks,

Stephen


signature.asc
Description: Digital signature

Re: [HACKERS] feature request: pg_dump --view

[Neil Conway]

On Tue, 2006-07-18 at 18:06 -0400, Phil Frost wrote:
> I could really use a --view option to pg_dump (and pg_restore, i
> imagine). 

pg_dump -t  will work.

-Neil



---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [HACKERS] feature request: pg_dump --view

[Andrew Dunstan]

elein wrote:

pg_dump -t  will work.




Oh, you got me all worked up.  I was reading this as a way to
dump the CONTENTS of a view not the DEFINITION of a view.
I thought someone sneaked in pg_dump of a query in there.

  


How would you load such a dump, since views are by default select-only?

cheers

andrew

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] feature request: pg_dump --view

[elein]

On Tue, Jul 18, 2006 at 03:48:52PM -0700, Neil Conway wrote:
> On Tue, 2006-07-18 at 18:06 -0400, Phil Frost wrote:
> > I could really use a --view option to pg_dump (and pg_restore, i
> > imagine). 
> 
> pg_dump -t  will work.
> 
> -Neil
> 

Oh, you got me all worked up.  I was reading this as a way to
dump the CONTENTS of a view not the DEFINITION of a view.
I thought someone sneaked in pg_dump of a query in there.

--elein

> 
> 
> ---(end of broadcast)---
> TIP 6: explain analyze is your friend
> 

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org

[HACKERS] feature request: pg_dump --view

[Phil Frost]

I could really use a --view option to pg_dump (and pg_restore, i
imagine). This would instruct pg_dump to dump just a named view, much
like --table, --trigger, --function, etc. Could this maybe be added to a
todo list?

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match