diff options
Diffstat (limited to 'contrib')
| -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 | ||||
| -rw-r--r-- | contrib/oid2name/oid2name.c | 2 | ||||
| -rw-r--r-- | contrib/reindexdb/reindexdb | 4 | ||||
| -rw-r--r-- | contrib/seg/README.seg | 2 |
7 files changed, 14 insertions, 14 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: diff --git a/contrib/oid2name/oid2name.c b/contrib/oid2name/oid2name.c index 5fd1140f9ab..9bea98b507a 100644 --- a/contrib/oid2name/oid2name.c +++ b/contrib/oid2name/oid2name.c @@ -518,7 +518,7 @@ main(int argc, char **argv) if (my_opts->dbname == NULL) { - my_opts->dbname = "template1"; + my_opts->dbname = "postgres"; my_opts->nodb = true; } pgconn = sql_conn(my_opts); diff --git a/contrib/reindexdb/reindexdb b/contrib/reindexdb/reindexdb index 7db6a266222..cfe933126bd 100644 --- a/contrib/reindexdb/reindexdb +++ b/contrib/reindexdb/reindexdb @@ -1,6 +1,6 @@ #!/bin/sh # -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- # -# Package : reindexdb Version : $Revision: 1.5 $ +# Package : reindexdb Version : $Revision: 1.6 $ # Date : 05/08/2002 Author : Shaun Thomas # Req : psql, sh, perl, sed Type : Utility # @@ -174,7 +174,7 @@ if [ "$alldb" ]; then # connect to. That's the list we'll be using. It's also why it's # a good idea for this to be run as a super-user. sql='SELECT datname FROM pg_database WHERE datallowconn' - dbname=`$PSQL $PSQLOPT -q -t -A -d template1 -c "$sql"` + dbname=`$PSQL $PSQLOPT -q -t -A -d postgres -c "$sql"` # Ok, if it's not all databases, make sure at least one database is # specified before continuing. diff --git a/contrib/seg/README.seg b/contrib/seg/README.seg index f899b9394d1..e738f180e8a 100644 --- a/contrib/seg/README.seg +++ b/contrib/seg/README.seg @@ -159,7 +159,7 @@ Any number (rules 5,6) -- creates a zero-length segment (a point, boundaries. For example, it adds an extra digit to the lower boundary if the resulting interval includes a power of ten: - template1=> select '10(+-)1'::seg as seg; + postgres=> select '10(+-)1'::seg as seg; seg --------- 9.0 .. 11 -- should be: 9 .. 11 |