Postgres Pro
Downloads
Home   >   mailing lists

Can anyone confirm the flaw of postgres and how to deal with it? - Mailing list pgsql-general

From Shaozhong SHI
Subject Can anyone confirm the flaw of postgres and how to deal with it?
Date
Msg-id CA+i5Jwa8gwQ+7tg0T_PrRFeY8qbMAitLm5FsDyca6ZhVEbgF3Q@mail.gmail.com
Whole thread Raw
Responses 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>)
List pgsql-general
Tree view
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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: PostgreSQL 10.20 crashes / Antivirus
Next
From: "David G. Johnston"
Date:
Subject: Re: Can anyone confirm the flaw of postgres and how to deal with it?