Where did the data go?

Hi all, dumb question here. With the excellent help of Vibhor I was able to copy a txt file into a table. When I execute
the select command I get the following (so I am pretty sure the data is in a table called test_copy in a database called test)

test=# select * from test_copy;
id1 | id2 | id3
-----+-----+-----
1 | 2 | 3
4 | 5 | 6
7 | 8 | 9
(3 rows)

However, when I go into pgAdmin there is absolutely no evidence of a table called test_copy, nor of any data. I guess I am misunderstanding what pgAdmin is for, but I would have thought that at least the table would show up? Under "test" all I see are catalogs, schemas and replication.

Thanks for your insights.

-- Mark

mark_Smith wrote:
However, when I go into pgAdmin there is absolutely no evidence of a table called test_copy, nor of any data. I guess I am misunderstanding what pgAdmin is for, but I would have thought that at least the table would show up? Under "test" all I see are catalogs, schemas and replication.

Hi Mark,

Tables live in a schema, so if you expand the 'Schemas' node you see, and (probably) the 'public' schema, you should see a bunch more collection nodes including 'Tables', which should contain your table.

Dave_P wrote:

Hi Mark,

Tables live in a schema, so if you expand the 'Schemas' node you see, and (probably) the 'public' schema, you should see a bunch more collection nodes including 'Tables', which should contain your table.

They are indeed there. Thanks Dave.