Can anyone confirm the flaw of postgres and how to deal with it?

Поиск
Список
Период
Сортировка
От Shaozhong SHI
Тема Can anyone confirm the flaw of postgres and how to deal with it?
Дата
Msg-id CA+i5Jwa8gwQ+7tg0T_PrRFeY8qbMAitLm5FsDyca6ZhVEbgF3Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: Can anyone confirm the flaw of postgres and how to deal with it?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Can anyone confirm the flaw of postgres and how to deal with it?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Дерево обсуждения
I loaded several tables onto Postgres.

When you view, you can see all columns.

However, there are 'ghost columns' that I remember I used before, but not now.

 select column_name::text from information_schema.columns where table_name=a_table

keeps listing columns that I can not see in the current table.

Why does this happen?

What is the solution?

Regards,

David

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: PostgreSQL 10.20 crashes / Antivirus
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Can anyone confirm the flaw of postgres and how to deal with it?