Mark,
> I'm posting a function here in the hope others may find it useful
> and/or correct my mistakes/make improvements :)
Thanks! Way cool!
> Is there any existing site (a wiki for example) for posting PostgreSQL
> specific tips?
> (Wasn't sure if pgsql-sql is the right place for this ki
> Hello,
>I'm posting a function here in the hope others may find it useful
> and/or correct my mistakes/make improvements :)
>
> This creates a view of a remote table, using dblink:
...
> Is there any existing site (a wiki for example) for posting PostgreSQL
> specific tips?
The PG cookbook
Hello,
I'm posting a function here in the hope others may find it useful
and/or correct my mistakes/make improvements :)
This creates a view of a remote table, using dblink:
CREATE OR REPLACE FUNCTION dblink_create_view(text, text, text)
RETURNS VOID
LANGUAGE plpgsql
STRICT
AS '
DECLARE
connst
