Executing Raw Queries

​

Syntax

EXECUTE <peer_name>(<query_text>);

• <peer_name> must be the name of an existing peer.
• <query_text> is a string literal containing the SQL to run on the remote peer.

​

Examples

EXECUTE postgres_peer('SELECT id, name FROM public.users WHERE id < 10;');

EXECUTE postgres_peer('CREATE TEMP TABLE tmp_select AS SELECT id FROM public.users LIMIT 100;');

​

Behavior

• The query text is forwarded verbatim to the remote database connection associated with the peer.
• Results are returned to the caller exactly as the remote database would return them.

​

Considerations

1. The remote query runs with the credentials configured for the peer. Ensure the peer’s credentials have the minimal privileges required.
2. Since the query runs directly on the remote system, it can modify data or schema. Be cautious when running DDL or DML via EXECUTE in production environments.
3. The query must use the dialect and capabilities of the remote database type.