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