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

On 4/20/22 08:47, Shaozhong SHI wrote:
> 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

Best guess is that since you are not filtering on table_schema you are 
seeing columns for tables with table_name=a_table across all schemas.

> 
> keeps listing columns that I can not see in the current table.
> 
> Why does this happen?
> 
> What is the solution?
> 
> Regards,
> 
> David


-- 
Adrian Klaver
adrian.klaver@aklaver.com