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@xxxxxxxxxxx
