diff options
Diffstat (limited to 'contrib/dblink')
| -rw-r--r-- | contrib/dblink/doc/connection | 4 | ||||
| -rw-r--r-- | contrib/dblink/doc/cursor | 6 | ||||
| -rw-r--r-- | contrib/dblink/doc/misc | 4 | ||||
| -rw-r--r-- | contrib/dblink/doc/query | 6 |
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: |
