i am trying to access sql database in pgadminIII. Using postgres_fdw I am trying to connect. But I am struck in the middle..Following are the steps I followed
CREATE EXTENSION postgres_fdw;
CREATE SERVER ws253 FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host '192.168.0.253', dbname 'allahabad', port '1433');
CREATE USER MAPPING FOR postgres SERVER ws253 OPTIONS (user 'sa', password 'track');
CREATE FOREIGN TABLE routing
(
gid serial NOT NULL,
name character varying(255),
district character varying(255),
state character varying(255),
the_geom geometry,
name_hindi character varying,
name_hindi_display character varying(255)
)
SERVER ws253;
What is the next step I have to do?
