diff options
Diffstat (limited to 'src/bin/scripts')
| -rw-r--r-- | src/bin/scripts/clusterdb | 29 | ||||
| -rw-r--r-- | src/bin/scripts/createdb | 27 | ||||
| -rw-r--r-- | src/bin/scripts/createlang.sh | 19 | ||||
| -rw-r--r-- | src/bin/scripts/createuser | 37 | ||||
| -rw-r--r-- | src/bin/scripts/dropdb | 19 | ||||
| -rw-r--r-- | src/bin/scripts/droplang | 17 | ||||
| -rw-r--r-- | src/bin/scripts/dropuser | 19 | ||||
| -rw-r--r-- | src/bin/scripts/vacuumdb | 31 |
8 files changed, 107 insertions, 91 deletions
diff --git a/src/bin/scripts/clusterdb b/src/bin/scripts/clusterdb index 1b2bd6c0b30..bc66c319765 100644 --- a/src/bin/scripts/clusterdb +++ b/src/bin/scripts/clusterdb @@ -11,7 +11,7 @@ # # # IDENTIFICATION -# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/clusterdb,v 1.6 2002/10/16 03:44:28 momjian Exp $ +# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/clusterdb,v 1.7 2002/10/18 22:05:36 petere Exp $ # #------------------------------------------------------------------------- @@ -109,22 +109,25 @@ do done if [ "$usage" ]; then - echo "$CMDNAME cluster all previously clustered tables in a database" + echo "$CMDNAME cluster all previously clustered tables in a database." echo echo "Usage:" - echo " $CMDNAME [options] [dbname]" + echo " $CMDNAME [OPTION]... [DBNAME]" echo echo "Options:" - echo " -h, --host=HOSTNAME Database server host" - echo " -p, --port=PORT Database server port" - echo " -U, --username=USERNAME Username to connect as" - echo " -W, --password Prompt for password" - echo " -d, --dbname=DBNAME Database to cluster" - echo " -a, --all Cluster all databases" - echo " -t, --table='TABLE' Cluster specific table only" - echo " -v, --verbose Write a lot of output" - echo " -e, --echo Show the command being sent to the backend" - echo " -q, --quiet Don't write any output" + echo " -a, --all cluster all databases" + echo " -d, --dbname=DBNAME database to cluster" + echo " -t, --table='TABLE' cluster specific table only" + echo " -e, --echo show the command being sent to the backend" + echo " -q, --quiet don't write any output" + echo " -v, --verbose write a lot of output" + echo " --help show this help, then exit" + echo + echo "Connection options:" + echo " -h, --host=HOSTNAME database server host" + echo " -p, --port=PORT database server port" + echo " -U, --username=USERNAME user name to connect as" + echo " -W, --password prompt for password" echo echo "Read the description of the SQL command CLUSTER for details." echo diff --git a/src/bin/scripts/createdb b/src/bin/scripts/createdb index e951ed40a0d..751de6cd223 100644 --- a/src/bin/scripts/createdb +++ b/src/bin/scripts/createdb @@ -12,7 +12,7 @@ # # # IDENTIFICATION -# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/createdb,v 1.27 2002/10/16 03:44:28 momjian Exp $ +# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/createdb,v 1.28 2002/10/18 22:05:36 petere Exp $ # #------------------------------------------------------------------------- @@ -134,19 +134,22 @@ if [ "$usage" ]; then echo "$CMDNAME creates a PostgreSQL database." echo echo "Usage:" - echo " $CMDNAME [options] [dbname] [description]" + echo " $CMDNAME [OPTION]... [DBNAME] [DESCRIPTION]" echo echo "Options:" - echo " -O, --owner=OWNER Database user to own the new database" - echo " -D, --location=PATH Alternative place to store the database" - echo " -T, --template=TEMPLATE Template database to copy" - echo " -E, --encoding=ENCODING Encoding for the database" - echo " -h, --host=HOSTNAME Database server host" - echo " -p, --port=PORT Database server port" - echo " -U, --username=USERNAME Username to connect as" - echo " -W, --password Prompt for password" - echo " -e, --echo Show the query being sent to the backend" - echo " -q, --quiet Don't write any messages" + echo " -D, --location=PATH alternative place to store the database" + echo " -E, --encoding=ENCODING encoding for the database" + echo " -O, --owner=OWNER database user to own the new database" + echo " -T, --template=TEMPLATE template database to copy" + echo " -e, --echo show the query being sent to the backend" + echo " -q, --quiet don't write any messages" + echo " --help show this help, then exit" + echo + echo "Connection options:" + echo " -h, --host=HOSTNAME database server host" + echo " -p, --port=PORT database server port" + echo " -U, --username=USERNAME user name to connect as" + echo " -W, --password prompt for password" echo echo "By default, a database with the same name as the current user is created." echo diff --git a/src/bin/scripts/createlang.sh b/src/bin/scripts/createlang.sh index 5ef9fffe4b7..ff94874413f 100644 --- a/src/bin/scripts/createlang.sh +++ b/src/bin/scripts/createlang.sh @@ -7,7 +7,7 @@ # Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # -# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/createlang.sh,v 1.41 2002/10/16 03:44:28 momjian Exp $ +# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/createlang.sh,v 1.42 2002/10/18 22:05:36 petere Exp $ # #------------------------------------------------------------------------- @@ -130,16 +130,17 @@ if [ -n "$usage" ]; then echo "$CMDNAME installs a procedural language into a PostgreSQL database." echo echo "Usage:" - echo " $CMDNAME [options] langname [dbname]" + echo " $CMDNAME [OPTION]... LANGNAME [DBNAME]" echo echo "Options:" - echo " -h, --host=HOSTNAME Database server host" - echo " -p, --port=PORT Database server port" - echo " -U, --username=USERNAME Username to connect as" - echo " -W, --password Prompt for password" - echo " -d, --dbname=DBNAME Database to install language in" - echo " -L, --pglib=DIRECTORY Find language interpreter file in DIRECTORY" - echo " -l, --list Show a list of currently installed languages" + echo " -d, --dbname=DBNAME database to install language in" + echo " -l, --list show a list of currently installed languages" + echo " -L, --pglib=DIRECTORY find language interpreter file in DIRECTORY" + echo " -h, --host=HOSTNAME database server host" + echo " -p, --port=PORT database server port" + echo " -U, --username=USERNAME user name to connect as" + echo " -W, --password prompt for password" + echo " --help show this help, then exit" echo echo "Report bugs to <pgsql-bugs@postgresql.org>." exit 0 diff --git a/src/bin/scripts/createuser b/src/bin/scripts/createuser index ee758bdb872..f3983cfcba3 100644 --- a/src/bin/scripts/createuser +++ b/src/bin/scripts/createuser @@ -9,7 +9,7 @@ # # # IDENTIFICATION -# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/createuser,v 1.28 2002/10/16 03:44:28 momjian Exp $ +# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/createuser,v 1.29 2002/10/18 22:05:36 petere Exp $ # # Note - this should NOT be setuid. # @@ -141,25 +141,28 @@ if [ "$usage" ]; then echo "$CMDNAME creates a new PostgreSQL user." echo echo "Usage:" - echo " $CMDNAME [options] [username]" + echo " $CMDNAME [OPTION]... [USERNAME]" echo echo "Options:" - echo " -d, --createdb User can create new databases" - echo " -D, --no-createdb User cannot create databases" - echo " -a, --adduser User can add new users" - echo " -A, --no-adduser User cannot add new users" - echo " -i, --sysid=SYSID Select sysid for new user" - echo " -P, --pwprompt Assign a password to new user" - echo " -E, --encrypted Encrypt stored password" - echo " -N, --unencrypted Do no encrypt stored password" - echo " -h, --host=HOSTNAME Database server host" - echo " -p, --port=PORT Database server port" - echo " -U, --username=USERNAME Username to connect as (not the one to create)" - echo " -W, --password Prompt for password to connect" - echo " -e, --echo Show the query being sent to the backend" - echo " -q, --quiet Don't write any messages" + echo " -a, --adduser user can add new users" + echo " -A, --no-adduser user cannot add new users" + echo " -d, --createdb user can create new databases" + echo " -D, --no-createdb user cannot create databases" + echo " -P, --pwprompt assign a password to new user" + echo " -E, --encrypted encrypt stored password" + echo " -N, --unencrypted do no encrypt stored password" + echo " -i, --sysid=SYSID select sysid for new user" + echo " -e, --echo show the query being sent to the backend" + echo " -q, --quiet don't write any messages" + echo " --help show this help, then exit" echo - echo "If one of -d, -D, -a, -A, and 'username' is not specified, you will" + echo "Connection options:" + echo " -h, --host=HOSTNAME database server host" + echo " -p, --port=PORT database server port" + echo " -U, --username=USERNAME user name to connect as (not the one to create)" + echo " -W, --password prompt for password to connect" + echo + echo "If one of -a, -A, -d, -D, and USERNAME is not specified, you will" echo "be prompted interactively." echo echo "Report bugs to <pgsql-bugs@postgresql.org>." diff --git a/src/bin/scripts/dropdb b/src/bin/scripts/dropdb index 92892f6d1cd..e8df0d5a5e4 100644 --- a/src/bin/scripts/dropdb +++ b/src/bin/scripts/dropdb @@ -11,7 +11,7 @@ # # # IDENTIFICATION -# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/dropdb,v 1.18 2002/10/16 03:44:28 momjian Exp $ +# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/dropdb,v 1.19 2002/10/18 22:05:36 petere Exp $ # #------------------------------------------------------------------------- @@ -104,16 +104,17 @@ if [ "$usage" ]; then echo "$CMDNAME removes a PostgreSQL database." echo echo "Usage:" - echo " $CMDNAME [options] dbname" + echo " $CMDNAME [OPTION]... DBNAME" echo echo "Options:" - echo " -h, --host=HOSTNAME Database server host" - echo " -p, --port=PORT Database server port" - echo " -U, --username=USERNAME Username to connect as" - echo " -W, --password Prompt for password" - echo " -i, --interactive Prompt before deleting anything" - echo " -e, --echo Show the query being sent to the backend" - echo " -q, --quiet Don't write any messages" + echo " -e, --echo show the query being sent to the backend" + echo " -i, --interactive prompt before deleting anything" + echo " -q, --quiet don't write any messages" + echo " -h, --host=HOSTNAME database server host" + echo " -p, --port=PORT database server port" + echo " -U, --username=USERNAME user name to connect as" + echo " -W, --password prompt for password" + echo " --help show this help, then exit" echo echo "Report bugs to <pgsql-bugs@postgresql.org>." exit 0 diff --git a/src/bin/scripts/droplang b/src/bin/scripts/droplang index 8d90250c5d9..5792e795ecf 100644 --- a/src/bin/scripts/droplang +++ b/src/bin/scripts/droplang @@ -7,7 +7,7 @@ # Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # -# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/droplang,v 1.26 2002/10/16 03:44:28 momjian Exp $ +# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/droplang,v 1.27 2002/10/18 22:05:36 petere Exp $ # #------------------------------------------------------------------------- @@ -120,15 +120,16 @@ if [ "$usage" ]; then echo "$CMDNAME removes a procedural language from a database." echo echo "Usage:" - echo " $CMDNAME [options] langname [dbname]" + echo " $CMDNAME [OPTION]... LANGNAME [DBNAME]" echo echo "Options:" - echo " -h, --host=HOSTNAME Database server host" - echo " -p, --port=PORT Database server port" - echo " -U, --username=USERNAME Username to connect as" - echo " -W, --password Prompt for password" - echo " -d, --dbname=DBNAME Database to remove language from" - echo " -l, --list Show a list of currently installed languages" + echo " -d, --dbname=DBNAME database to remove language from" + echo " -l, --list show a list of currently installed languages" + echo " -h, --host=HOSTNAME database server host" + echo " -p, --port=PORT database server port" + echo " -U, --username=USERNAME user name to connect as" + echo " -W, --password prompt for password" + echo " --help show this help, then exit" echo echo "Report bugs to <pgsql-bugs@postgresql.org>." exit 0 diff --git a/src/bin/scripts/dropuser b/src/bin/scripts/dropuser index 49cbf7fc639..af113051160 100644 --- a/src/bin/scripts/dropuser +++ b/src/bin/scripts/dropuser @@ -9,7 +9,7 @@ # # # IDENTIFICATION -# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/dropuser,v 1.20 2002/10/16 03:44:28 momjian Exp $ +# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/dropuser,v 1.21 2002/10/18 22:05:36 petere Exp $ # # Note - this should NOT be setuid. # @@ -110,16 +110,17 @@ if [ "$usage" ]; then echo "$CMDNAME removes a PostgreSQL user." echo echo "Usage:" - echo " $CMDNAME [options] [username]" + echo " $CMDNAME [OPTION]... [USERNAME]" echo echo "Options:" - echo " -h, --host=HOSTNAME Database server host" - echo " -p, --port=PORT Database server port" - echo " -U, --username=USERNAME Username to connect as (not the one to drop)" - echo " -W, --password Prompt for password to connect" - echo " -i, --interactive Prompt before deleting anything" - echo " -e, --echo Show the query being sent to the backend" - echo " -q, --quiet Don't write any messages" + echo " -e, --echo show the query being sent to the backend" + echo " -i, --interactive prompt before deleting anything" + echo " -q, --quiet don't write any messages" + echo " -h, --host=HOSTNAME database server host" + echo " -p, --port=PORT database server port" + echo " -U, --username=USERNAME user name to connect as (not the one to drop)" + echo " -W, --password prompt for password to connect" + echo " --help show this help, then exit" echo echo "Report bugs to <pgsql-bugs@postgresql.org>." exit 0 diff --git a/src/bin/scripts/vacuumdb b/src/bin/scripts/vacuumdb index b1ac81f489e..1a0e9114550 100644 --- a/src/bin/scripts/vacuumdb +++ b/src/bin/scripts/vacuumdb @@ -12,7 +12,7 @@ # # # IDENTIFICATION -# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/vacuumdb,v 1.25 2002/10/16 03:44:28 momjian Exp $ +# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/vacuumdb,v 1.26 2002/10/18 22:05:36 petere Exp $ # #------------------------------------------------------------------------- @@ -126,21 +126,24 @@ if [ "$usage" ]; then echo "$CMDNAME cleans and analyzes a PostgreSQL database." echo echo "Usage:" - echo " $CMDNAME [options] [dbname]" + echo " $CMDNAME [OPTION]... [DBNAME]" echo echo "Options:" - echo " -h, --host=HOSTNAME Database server host" - echo " -p, --port=PORT Database server port" - echo " -U, --username=USERNAME Username to connect as" - echo " -W, --password Prompt for password" - echo " -d, --dbname=DBNAME Database to vacuum" - echo " -a, --all Vacuum all databases" - echo " -t, --table='TABLE[(columns)]' Vacuum specific table only" - echo " -f, --full Do full vacuuming" - echo " -v, --verbose Write a lot of output" - echo " -z, --analyze Update optimizer hints" - echo " -e, --echo Show the command being sent to the backend" - echo " -q, --quiet Don't write any output" + echo " -a, --all vacuum all databases" + echo " -d, --dbname=DBNAME database to vacuum" + echo " -t, --table='TABLE[(columns)]' vacuum specific table only" + echo " -f, --full do full vacuuming" + echo " -z, --analyze update optimizer hints" + echo " -e, --echo show the command being sent to the backend" + echo " -q, --quiet don't write any output" + echo " -v, --verbose write a lot of output" + echo " --help show this help, then exit" + echo + echo "Connection options:" + echo " -h, --host=HOSTNAME database server host" + echo " -p, --port=PORT database server port" + echo " -U, --username=USERNAME user name to connect as" + echo " -W, --password prompt for password" echo echo "Read the description of the SQL command VACUUM for details." echo |