Re: [HACKERS] Dumping of views -- done!

Hi Jan

On Mon, 5 Oct 1998, Jan Wieck wrote:

>     Took a look at the patch. Terry's using the new  system  view
>     pg_views for it. But...
>
>     IMHO the better way would be to dump views as regular  CREATE
>     TABLE  statements  and  just omit the data (views have none).
>     After all tables are restored and  all  functions,  operators
>     and  operator classes are created, we should dump rules using
>     the pg_rules view.
>
Well, if you see need to do it differant, you most certainly know more
about it then me, so sure.

I am confused though ....
How is "CREATE TABLE ...." going to become "CREATE VIEW ....."????

Note also, that the way I did it kept in mind that some day we will have
outer joins, at which time most of the code I put in getTables() can come
out, and just make a very minor change to the main query to get the view
info all at one time.

If there is a cleaner way to do it though, then that is the way to do it,
I just do not understand what  it is you said.

I am lacking time today to really think about it, but will take time
tonight maybe to look at pg_rules and such.

Have a great day
Terry Mackintosh <terry@terrym.com>          http://www.terrym.com
sysadmin/owner  Please! No MIME encoded or HTML mail, unless needed.

Proudly powered by R H Linux 4.2, Apache 1.3, PHP 3, PostgreSQL 6.3
-------------------------------------------------------------------
Success Is A Choice ... book by Rick Patino, get it, read it!