postgres_fdw

<TabPanel id="dashboard" label="Dashboard">

    1. Go to the [Database](/dashboard/project/_/database/tables) page in the Dashboard.
    2. Click on **Extensions** in the sidebar.
    3. Search for "postgres_fdw" and enable the extension.

</TabPanel>
<TabPanel id="sql" label="SQL">

    ```sql
    -- Example: enable the "postgres_fdw" extension
    create extension if not exists postgres_fdw;

    -- Example: disable the "postgres_fdw" extension
    drop extension if exists postgres_fdw;
    ```

    Procedural languages are automatically installed within `pg_catalog`, so you don't need to specify a schema.

</TabPanel>

        Define the remote database address

    </StepHikeCompact.Details>
    <StepHikeCompact.Code>
        ```sql
            create server "<foreign_server_name>"
            foreign data wrapper postgres_fdw
            options (
                host '<host>',
                port '<port>',
                dbname '<dbname>'
            );
        ```
    </StepHikeCompact.Code>
</StepHikeCompact.Step>

<StepHikeCompact.Step step={2}>
    <StepHikeCompact.Details title="Create a server mapping">
        Set the user credentials for the remote server
    </StepHikeCompact.Details>
    <StepHikeCompact.Code>
        ```sql
        create user mapping for "<dbname>"
        server "<foreign_server_name>"
        options (
            user '<db_user>',
            password '<password>'
        );
        ```
    </StepHikeCompact.Code>
</StepHikeCompact.Step>

<StepHikeCompact.Step step={3}>
    <StepHikeCompact.Details title="Import tables">
        Import tables from the foreign database
    </StepHikeCompact.Details>
    <StepHikeCompact.Code>
        Example: Import all tables from a schema
        ```sql
        import foreign schema "<foreign_schema>"
        from server "<foreign_server>"
        into "<host_schema>";
        ```

        Example: Import specific tables
        ```sql
        import foreign schema "<foreign_schema>"
        limit to (
            "<table_name1>",
            "<table_name2>"
        )
        from server "<foreign_server>"
        into "<host_schema>";
        ```
    </StepHikeCompact.Code>
</StepHikeCompact.Step>
<StepHikeCompact.Step step={4}>
    <StepHikeCompact.Details title="Query foreign table"/>
    <StepHikeCompact.Code>

        ```sql
        select * from "<foreign_table>"
        ```
    </StepHikeCompact.Code>
</StepHikeCompact.Step>

alter server "<foreign_server_name>"
options (fetch_size '10000');

alter server "<foreign_server_name>"
options (batch_size '1000');

alter server "<foreign_server_name>"
options (extensions 'vector, postgis');