|
26 | 26 | # |
27 | 27 | # |
28 | 28 | # IDENTIFICATION |
29 | | -# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.68 1999/12/1703:46:33 momjian Exp $ |
| 29 | +# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.69 1999/12/1716:53:11 wieck Exp $ |
30 | 30 | # |
31 | 31 | #------------------------------------------------------------------------- |
32 | 32 |
|
@@ -438,71 +438,71 @@ echo "COPY pg_shadow TO '$PGDATA/pg_pwd' USING DELIMITERS '\\t'" \ |
438 | 438 | chmod go-rw$PGDATA/pg_pwd|| exit_nicely |
439 | 439 |
|
440 | 440 | echo"Creating view pg_user." |
441 | | -echo"CREATE VIEW pg_user AS |
442 | | - SELECT |
443 | | - usename, |
444 | | - usesysid, |
445 | | - usecreatedb, |
446 | | - usetrace, |
447 | | - usesuper, |
448 | | - usecatupd, |
449 | | - '********'::text as passwd, |
450 | | - valuntil |
| 441 | +echo"CREATE VIEW pg_user AS\ |
| 442 | + SELECT\ |
| 443 | + usename,\ |
| 444 | + usesysid,\ |
| 445 | + usecreatedb,\ |
| 446 | + usetrace,\ |
| 447 | + usesuper,\ |
| 448 | + usecatupd,\ |
| 449 | + '********'::text as passwd,\ |
| 450 | + valuntil\ |
451 | 451 | FROM pg_shadow" \ |
452 | 452 | |$PGPATH/postgres$PGSQL_OPT template1> /dev/null|| exit_nicely |
453 | 453 |
|
454 | 454 | echo"REVOKE ALL on pg_shadow FROM public" \ |
455 | 455 | |$PGPATH/postgres$PGSQL_OPT template1> /dev/null|| exit_nicely |
456 | 456 |
|
457 | 457 | echo"Creating view pg_rules." |
458 | | -echo"CREATE VIEW pg_rules AS |
459 | | - SELECT |
460 | | - C.relname AS tablename, |
461 | | - R.rulename AS rulename, |
462 | | - pg_get_ruledef(R.rulename) AS definition |
463 | | -FROM pg_rewrite R, pg_class C |
464 | | -WHERE R.rulename !~ '^_RET' |
| 458 | +echo"CREATE VIEW pg_rules AS\ |
| 459 | + SELECT\ |
| 460 | + C.relname AS tablename,\ |
| 461 | + R.rulename AS rulename,\ |
| 462 | + pg_get_ruledef(R.rulename) AS definition\ |
| 463 | +FROM pg_rewrite R, pg_class C\ |
| 464 | +WHERE R.rulename !~ '^_RET'\ |
465 | 465 | AND C.oid = R.ev_class;" \ |
466 | 466 | |$PGPATH/postgres$PGSQL_OPT template1> /dev/null|| exit_nicely |
467 | 467 |
|
468 | 468 | echo"Creating view pg_views." |
469 | | -echo"CREATE VIEW pg_views AS |
470 | | - SELECT |
471 | | - C.relname AS viewname, |
472 | | - pg_get_userbyid(C.relowner) AS viewowner, |
473 | | - pg_get_viewdef(C.relname) AS definition |
474 | | - FROM pg_class C |
475 | | - WHERE C.relhasrules |
476 | | - ANDEXISTS ( |
477 | | - SELECT rulename FROM pg_rewrite R |
478 | | - WHERE ev_class = C.oid AND ev_type = '1' |
| 469 | +echo"CREATE VIEW pg_views AS\ |
| 470 | + SELECT\ |
| 471 | + C.relname AS viewname,\ |
| 472 | + pg_get_userbyid(C.relowner) AS viewowner,\ |
| 473 | + pg_get_viewdef(C.relname) AS definition\ |
| 474 | + FROM pg_class C\ |
| 475 | + WHERE C.relhasrules\ |
| 476 | + ANDEXISTS (\ |
| 477 | + SELECT rulename FROM pg_rewrite R\ |
| 478 | + WHERE ev_class = C.oid AND ev_type = '1'\ |
479 | 479 | )" \ |
480 | 480 | |$PGPATH/postgres$PGSQL_OPT template1> /dev/null|| exit_nicely |
481 | 481 |
|
482 | 482 | echo"Creating view pg_tables." |
483 | | -echo"CREATE VIEW pg_tables AS |
484 | | - SELECT |
485 | | - C.relname AS tablename, |
486 | | - pg_get_userbyid(C.relowner) AS tableowner, |
487 | | - C.relhasindex AS hasindexes, |
488 | | - C.relhasrules AS hasrules, |
489 | | - (C.reltriggers > 0) AS hastriggers |
490 | | - FROM pg_class C |
491 | | - WHERE C.relkind IN ('r', 's') |
492 | | - AND NOT EXISTS ( |
493 | | - SELECT rulename FROM pg_rewrite |
494 | | - WHERE ev_class = C.oid AND ev_type = '1' |
| 483 | +echo"CREATE VIEW pg_tables AS\ |
| 484 | + SELECT\ |
| 485 | + C.relname AS tablename,\ |
| 486 | + pg_get_userbyid(C.relowner) AS tableowner,\ |
| 487 | + C.relhasindex AS hasindexes,\ |
| 488 | + C.relhasrules AS hasrules,\ |
| 489 | + (C.reltriggers > 0) AS hastriggers\ |
| 490 | + FROM pg_class C\ |
| 491 | + WHERE C.relkind IN ('r', 's')\ |
| 492 | + AND NOT EXISTS (\ |
| 493 | + SELECT rulename FROM pg_rewrite\ |
| 494 | + WHERE ev_class = C.oid AND ev_type = '1'\ |
495 | 495 | )" \ |
496 | 496 | |$PGPATH/postgres$PGSQL_OPT template1> /dev/null|| exit_nicely |
497 | 497 |
|
498 | 498 | echo"Creating view pg_indexes." |
499 | | -echo"CREATE VIEW pg_indexes AS |
500 | | - SELECT |
501 | | - C.relname AS tablename, |
502 | | - I.relname AS indexname, |
503 | | - pg_get_indexdef(X.indexrelid) AS indexdef |
504 | | - FROM pg_index X, pg_class C, pg_class I |
505 | | -WHERE C.oid = X.indrelid |
| 499 | +echo"CREATE VIEW pg_indexes AS\ |
| 500 | + SELECT\ |
| 501 | + C.relname AS tablename,\ |
| 502 | + I.relname AS indexname,\ |
| 503 | + pg_get_indexdef(X.indexrelid) AS indexdef\ |
| 504 | + FROM pg_index X, pg_class C, pg_class I\ |
| 505 | +WHERE C.oid = X.indrelid\ |
506 | 506 | AND I.oid = X.indexrelid" \ |
507 | 507 | |$PGPATH/postgres$PGSQL_OPT template1> /dev/null|| exit_nicely |
508 | 508 |
|
|
