how to drop table named user

Поиск
Список
Период
Сортировка
От Patrick Hatcher
Тема how to drop table named user
Дата
Msg-id OF6103E215.DF3A001C-ON88256D89.0081960B-88256D89.00828120@fds.com
обсуждение исходный текст
Ответы Re: how to drop table named user
Список pgsql-general
We accidentally created a table called user  in our public schema.  We are
now trying to remove the table using DROP TABLE user and even DROP TABLE
public.user.  However every time we try we get an error message: ERROR:
parser: parse error at or near "user" at character 12

Any suggestion on how to remove this table?  I thought maybe going through
Pg Class, but I'm terrified of mucking something else up.
TIA

Patrick Hatcher



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

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: Buglist
Следующее
От: Doug McNaught
Дата:
Сообщение: Re: how to drop table named user