Обсуждение: creating documentation about user functions etc.
After using PostgreSQL (V 6.5.1) for a while I get more and more database applications. They are maily operated by a WEB-Interface. As in any database applicatio there are user defined tables, views, functions etc. Is there any convenient way to create a documentation of all my work? Thanks for any hints. - Werner - BTW: Is there any answer to my previously posted mail? Here is a copy in hope for answers :-)) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ I'm currently running PostgreSQL 6.5.1 and want to upgrade to 7.0. As adviced I ran pg_dumpall (V6.5.1) but I get the message server1:[pgsql] >pg_dumpall > db.out failed sanity check, type with oid 155265 was not found pg_dump failed on volleyball, exiting server1:[pgsql] > How can I solve this? Any hints? ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -- --------------------------------------- Werner Modenbach modenbach@alc.de ALC Computertechnik GmbH http://www.alc.de
At 18:40 2000-06-06 +0200, Werner Modenbach wrote: >After using PostgreSQL (V 6.5.1) for a while I get more and more database >applications. They are maily operated by a WEB-Interface. > >As in any database applicatio there are user defined tables, views, functions >etc. >Is there any convenient way to create a documentation of all my work? You can dump the structure with "pg_dump -s". That's a good start for recovering your work, but it's not really documentation. Tony -- Anthony E. Greene <agreene@pobox.com> PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26 C484 A42A 60DD 6C94 239D Linux: The choice of a GNU Generation.