Dropping a table

Поиск
Список
Период
Сортировка
От Mo Holkar
Тема Dropping a table
Дата
Msg-id 5.0.2.1.2.20010401183159.05addec0@pop.ntlworld.com
обсуждение исходный текст
Список pgsql-novice
Hi all,

Apols if the answer to this is obvious.

I'm using PostgreSQL 7.0.3 and using psql. I issue the command 'DROP TABLE
playermain' where playermain is a table that I own, but it doesn't seem to
have any effect. I don't get an error message, or a successful completion
message, and \d reveals that the table is still present. I do have the
CREATEDB ability.

This is what I'm seeing:

playerdb-# DROP TABLE playermain
playerdb-# \d
      List of relations
     Name    | Type  | Owner
------------+-------+-------
  playermain | table | mo
(1 row)


What am I doing wrong?

Thanks,

Mo



Mo Holkar
Digital Mind Games -- log on to take over
mo.holkar@digitalmindgames.com
http://www.digitalmindgames.com


В списке pgsql-novice по дате отправления:

Предыдущее
От: "IGB.NET"
Дата:
Сообщение: ...
Следующее
От: Mo Holkar
Дата:
Сообщение: Fwd: Dropping a table