1 /*-------------------------------------------------------------------------
5 * Portions Copyright (c) 1996-2010, PostgreSQL Global Development Group
6 * Portions Copyright (c) 1994, Regents of the University of California
8 * src/bin/scripts/dropdb.c
10 *-------------------------------------------------------------------------
13 #include "postgres_fe.h"
15 #include "dumputils.h"
18 static void help(const char *progname);
22 main(int argc, char *argv[])
24 static struct option long_options[] = {
25 {"host", required_argument, NULL, 'h'},
26 {"port", required_argument, NULL, 'p'},
27 {"username", required_argument, NULL, 'U'},
28 {"no-password", no_argument, NULL, 'w'},
29 {"password", no_argument, NULL, 'W'},
30 {"echo", no_argument, NULL, 'e'},
31 {"interactive", no_argument, NULL, 'i'},
42 char *username = NULL;
43 enum trivalue prompt_password = TRI_DEFAULT;
45 bool interactive = false;
52 progname = get_progname(argv[0]);
53 set_pglocale_pgservice(argv[0], PG_TEXTDOMAIN("pgscripts"));
55 handle_help_version_opts(argc, argv, "dropdb", help);
57 while ((c = getopt_long(argc, argv, "h:p:U:wWei", long_options, &optindex)) != -1)
71 prompt_password = TRI_NO;
74 prompt_password = TRI_YES;
83 fprintf(stderr, _("Try \"%s --help\" for more information.\n"), progname);
88 switch (argc - optind)
91 fprintf(stderr, _("%s: missing required argument database name\n"), progname);
92 fprintf(stderr, _("Try \"%s --help\" for more information.\n"), progname);
95 dbname = argv[optind];
98 fprintf(stderr, _("%s: too many command-line arguments (first is \"%s\")\n"),
99 progname, argv[optind + 1]);
100 fprintf(stderr, _("Try \"%s --help\" for more information.\n"), progname);
106 printf(_("Database \"%s\" will be permanently removed.\n"), dbname);
107 if (!yesno_prompt("Are you sure?"))
111 initPQExpBuffer(&sql);
113 appendPQExpBuffer(&sql, "DROP DATABASE %s;\n",
116 conn = connectDatabase(strcmp(dbname, "postgres") == 0 ? "template1" : "postgres",
117 host, port, username, prompt_password, progname);
120 printf("%s", sql.data);
121 result = PQexec(conn, sql.data);
122 if (PQresultStatus(result) != PGRES_COMMAND_OK)
124 fprintf(stderr, _("%s: database removal failed: %s"),
125 progname, PQerrorMessage(conn));
137 help(const char *progname)
139 printf(_("%s removes a PostgreSQL database.\n\n"), progname);
140 printf(_("Usage:\n"));
141 printf(_(" %s [OPTION]... DBNAME\n"), progname);
142 printf(_("\nOptions:\n"));
143 printf(_(" -e, --echo show the commands being sent to the server\n"));
144 printf(_(" -i, --interactive prompt before deleting anything\n"));
145 printf(_(" --help show this help, then exit\n"));
146 printf(_(" --version output version information, then exit\n"));
147 printf(_("\nConnection options:\n"));
148 printf(_(" -h, --host=HOSTNAME database server host or socket directory\n"));
149 printf(_(" -p, --port=PORT database server port\n"));
150 printf(_(" -U, --username=USERNAME user name to connect as\n"));
151 printf(_(" -w, --no-password never prompt for password\n"));
152 printf(_(" -W, --password force password prompt\n"));
153 printf(_("\nReport bugs to <pgsql-bugs@postgresql.org>.\n"));