Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
tag: v1.1.0
Fetching contributors…

Cannot retrieve contributors at this time

36 lines (28 sloc) 0.884 kb
/* contrib/twitter_fdw/twitter_fdw--1.0.sql */
-- create wrapper with validator and handler
CREATE OR REPLACE FUNCTION twitter_fdw_validator (text[], oid)
RETURNS bool
AS 'MODULE_PATHNAME'
LANGUAGE C STRICT;
CREATE OR REPLACE FUNCTION twitter_fdw_handler ()
RETURNS fdw_handler
AS 'MODULE_PATHNAME'
LANGUAGE C STRICT;
CREATE FOREIGN DATA WRAPPER twitter_fdw
VALIDATOR twitter_fdw_validator HANDLER twitter_fdw_handler;
CREATE SERVER twitter_service FOREIGN DATA WRAPPER twitter_fdw;
CREATE USER MAPPING FOR current_user SERVER twitter_service;
CREATE FOREIGN TABLE twitter(
id bigint,
text text,
from_user text,
from_user_id bigint,
to_user text,
to_user_id bigint,
iso_language_code text,
source text,
profile_image_url text,
created_at timestamp,
-- virtual columns for parameters
q text
) SERVER twitter_service;
Jump to Line
Something went wrong with that request. Please try again.