Re: My troubles with test PostgreSQL 8.1
Kevin Rosenberg <kevin-HJRc7zDS/[email protected]> Thu, 10 Nov 2005 15:09:52 -0700
| Newsgroups | gmane.lisp.clsql.devel |
|---|---|
| Message-ID | <[email protected]> |
John DeSoi wrote: > The parameters to dropdb is similar to all PostgreSQL command line > utilities: Hi John, Thanks for the postgresql tips. Connecting to stdin for dropdb and pass the password to dropdb's prompt would be secure. But, I doubt that'd be very portable across lisp implementation or operating systems. At this point, I think the current behavior is preferred to passing the SQL password on the command-line to dropdb. > But as far back as I remember, PostgreSQL has had a DROP DATABASE > command so I'm not sure why you would use the shell command other > than perhaps you don't have to specify a database to connect to. That's a good tip. I think DROP / CREATE DATABASE SQL statements would be preferable to the current behavior. Thanks for the thoughts, Kevin