summaryrefslogtreecommitdiff
path: root/contrib/dblink
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/dblink')
-rw-r--r--contrib/dblink/doc/connection4
-rw-r--r--contrib/dblink/doc/cursor6
-rw-r--r--contrib/dblink/doc/misc4
-rw-r--r--contrib/dblink/doc/query6
4 files changed, 10 insertions, 10 deletions
diff --git a/contrib/dblink/doc/connection b/contrib/dblink/doc/connection
index 251bd939618..c3ce776fbcc 100644
--- a/contrib/dblink/doc/connection
+++ b/contrib/dblink/doc/connection
@@ -28,13 +28,13 @@ Outputs
Example usage
-select dblink_connect('dbname=template1');
+select dblink_connect('dbname=postgres');
dblink_connect
----------------
OK
(1 row)
-select dblink_connect('myconn','dbname=template1');
+select dblink_connect('myconn','dbname=postgres');
dblink_connect
----------------
OK
diff --git a/contrib/dblink/doc/cursor b/contrib/dblink/doc/cursor
index 23a3ce89ba5..b989fcb69cc 100644
--- a/contrib/dblink/doc/cursor
+++ b/contrib/dblink/doc/cursor
@@ -44,7 +44,7 @@ Note
Example usage
-test=# select dblink_connect('dbname=template1');
+test=# select dblink_connect('dbname=postgres');
dblink_connect
----------------
OK
@@ -94,7 +94,7 @@ Outputs
Example usage
-test=# select dblink_connect('dbname=template1');
+test=# select dblink_connect('dbname=postgres');
dblink_connect
----------------
OK
@@ -175,7 +175,7 @@ Note
Example usage
-test=# select dblink_connect('dbname=template1');
+test=# select dblink_connect('dbname=postgres');
dblink_connect
----------------
OK
diff --git a/contrib/dblink/doc/misc b/contrib/dblink/doc/misc
index 21d241d61ba..596c9ecdcff 100644
--- a/contrib/dblink/doc/misc
+++ b/contrib/dblink/doc/misc
@@ -17,10 +17,10 @@ Outputs
Example usage
-test=# select dblink_current_query() from (select dblink('dbname=template1','select oid, proname from pg_proc where proname = ''byteacat''') as f1) as t1;
+test=# select dblink_current_query() from (select dblink('dbname=postgres','select oid, proname from pg_proc where proname = ''byteacat''') as f1) as t1;
dblink_current_query
-----------------------------------------------------------------------------------------------------------------------------------------------------
- select dblink_current_query() from (select dblink('dbname=template1','select oid, proname from pg_proc where proname = ''byteacat''') as f1) as t1;
+ select dblink_current_query() from (select dblink('dbname=postgres','select oid, proname from pg_proc where proname = ''byteacat''') as f1) as t1;
(1 row)
==================================================================
diff --git a/contrib/dblink/doc/query b/contrib/dblink/doc/query
index d232f80dbd9..cd58a361422 100644
--- a/contrib/dblink/doc/query
+++ b/contrib/dblink/doc/query
@@ -37,7 +37,7 @@ Outputs
Example usage
-select * from dblink('dbname=template1','select proname, prosrc from pg_proc')
+select * from dblink('dbname=postgres','select proname, prosrc from pg_proc')
as t1(proname name, prosrc text) where proname like 'bytea%';
proname | prosrc
------------+------------
@@ -55,7 +55,7 @@ select * from dblink('dbname=template1','select proname, prosrc from pg_proc')
byteaout | byteaout
(12 rows)
-select dblink_connect('dbname=template1');
+select dblink_connect('dbname=postgres');
dblink_connect
----------------
OK
@@ -111,7 +111,7 @@ A more convenient way to use dblink may be to create a view:
create view myremote_pg_proc as
select *
- from dblink('dbname=template1','select proname, prosrc from pg_proc')
+ from dblink('dbname=postgres','select proname, prosrc from pg_proc')
as t1(proname name, prosrc text);
Then you can simply write: