Why is pgadmin yelling at dblink?

Question

PostgreSQL

Hello!
I want to access the test_1 database via dblink from the test_2 database and get data from there. Well, at least some for starters.
I am writing a query like
select * from dblink (
'host=localhost user=postgres password=NeProstoParolAParolishe dbname=test_1',
'select * from v8users'
) as users (
rolesid numeric(10)
);
And he yells:
ERROR: remote query result rowtype does not match the specified FROM clause rowtype
SQL state: 42804

What doesn't he like?

Answer 1

You asked for select *, then you said that the records returned by the function correspond in structure to a single field of type numeric.
Everything in the truest sense

query result rowtype does not match the specified FROM clause rowtype

pgadmin has nothing to do with it, postgresql itself is naturally surprised at the request