| From: | Jonathon Batson <jonathon(at)octahedron(dot)com(dot)au> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Removing Database Names as Spaces? |
| Date: | 2004-08-19 00:38:00 |
| Message-ID: | 4123F668.2060904@octahedron.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi All
I have a script that went haywire and created 2 databases with what
looks like
empty names OR names made up of spaces. Here is the output of my psql
-l command
excluding the 1,2,3,4. As you can see dbs 1 and 3 seem to have no name.
psql -l
Name | Owner | Encoding
---------------+----------+-----------
| postgres | SQL_ASCII 1
swim | postgres | SQL_ASCII 2
| postgres | SQL_ASCII 3
swim_user_log | postgres | SQL_ASCII 4
My Question is: How do I remove these noname databases.....?
Commands that fail are ..
dropdb ' '
dropdb ' '
dropdb ' '
dropdb " "
dropdb " "
dropdb " "
dropdb " "
thanx
Jonathon
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-08-19 01:29:30 | Re: Removing Database Names as Spaces? |
| Previous Message | operationsengineer1 | 2004-08-18 23:57:32 | pgAdmin Connection |