lib/sh/db.sh pg_dump(), bin/pg_dump_vegbien: --format: use the long form of the formats to make the code self-documenting
bugfix: bin/pg_dump_vegbien: fixed arg-count check to allow passing command-line options to pg_dump via args
moved everything into /trunk/ to create the standard svn layout, for use with tools that require this (eg. git-svn). IMPORTANT: do NOT do an `svn up`. instead, re-use your working copy's existing files with `svn switch` (http://svnbook.red-bean.com/en/1.6/svn.ref.svn.c.switch.html).
pg_dump_vegbien: Renamed $opts env var to $dump_opts to avoid conflicting with other commands' vars of the same name
pg_dump_vegbien: non-$owners mode: Removed --no-privileges in order to include GRANTs to other users
pg_dump_vegbien: When not in data mode, use --inserts so the INSERT statements generated can be run directly in pgAdmin, they can be directly translated to MySQL, and an empty COPY FROM statement isn't generated for every table
pg_dump_vegbien: Except in (raw) data mode, filter out pg_catalog.setval() statements (only lookup table contents should be preserved)
pg_dump_vegbien: $schema flag defaults to on to export only schema
pg_dump_vegbien: Fixed bug where schema name var can't be named $schema because that would conflict with the $schema flag
pg_dump_vegbien: Only include just the schema if new $schema flag is set. This causes constant lookup tables to automatically be exported for DB schemas, which was not fully supported by the $data flag because it also forced $owners to be enabled.
pg_dump_vegbien: Added opts env var to allow specifying options to a Makefile command, which does not take positional arguments
pg_dump_vegbien: Don't use SET SESSION AUTHORIZATION because it doesn't work with the py_functions schema (it requires PL/Python functions to be created as user postgres and then the owner changed to bien, which SET SESSION AUTHORIZATION won't do)
pg_dump_vegbien: If first arg is "all", dump entire DB. Require a first arg so that Usage message will be displayed if run with no args.
Always output Usage messages to stderr and word-wrap them using `fold -s`
pg_dump_vegbien: For consistency with setting the --schema option, use `set -- "$" args...` to append options to $ which are then passed to pg_dump, instead of specifying several variables which are then included in the pg_dump command
" args...` to append options to $
pg_dump_vegbien: Pass command line options directly to pg_dump after parsing out any schema name
pg_dump_vegbien: Save owners when saving data (for full export)
pg_dump_vegbien: Use SET SESSION AUTHORIZATION to ensure that owners are always recorded in the same format. This will help make plain text backups comparable using diff.
pg_dump_vegbien: Added plain env var which creates plain text output instead, for use in debugging and validation
pg_dump_vegbien: Added data option for backing up an import's schema
pg_dump_vegbien: Enclose the schema name in "" because pg_dump requires this for schema names with special characters
pg_dump_vegbien: Fixed bug where needed space before $noOwners options
pg_dump_vegbien: Log the pg_dump command being run
pg_dump_vegbien: Support optionally including owners
Added pg_dump_vegbien to dump a schema of the vegbien db