Cannot Use External Queries

[elshafey]

Hi There,
I am trying to execute SELECT * FROM table(PostgreSQL.external_query('SELECT * FROM Actor')) but it gives me this error
No match found for function signature external_query().
I am using Community Version 20.0.0

[lenoyjacob]

@elshafey

@elshafey

SELECT * FROM table(PostgreSQL.external_query('SELECT * FROM Actor'))

Is “PostgreSQL” your source name? For example, for me “pg” is my source name:

So my query is:

SELECT * FROM table(pg.external_query('SELECT * FROM public.users'))

[elshafey]

solved. thx very much