Silly question, but did you try it with a semicolon after the drop table?
# drop table station_type;
I've noticed that if you are in the middle of a statement and issue a \ command, psql ignores the SQL you've typed in and just does the \ command.
On Tue, Jun 28, 2011 at 3:34 PM, Rich Shepard
<rshepard@appl-ecosys.com> wrote:
I cannot recall issuing a DROP TABLE command from psql that did not work,
but seem to have this as a new experience.
When I look at the database table list with '\d' I see
public | station_type | table | rshepard
public | station_type_statype_seq | sequence | rshepard
and I want to drop and recreate these with a typo fixed. But, the drop
commands do not appear to work:
# drop table station_type
# \d
public | station_type | table | rshepard
public | station_type_statype_seq | sequence | rshepard
I fail to see what I'm doing incorrectly and would appreciate a clue stick
to set me on the proper path.
TIA,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Rick Genter
rick.genter@gmail.com