What is this...?

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: What is this...?
Date: 1998-03-08 22:50:20
Message-ID: Pine.NEB.3.95.980308174817.29397E-100000@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


I might have missed somethign with all the dump/reload discussions that
went on, but what is:

postgres(at)zeus> psql -e -f db.dump template1
\connect template1
connecting to new database: template1
select datdba into table tmp_pguser from pg_database where datname =
'template1';
QUERY: select datdba into table tmp_pguser from pg_database where
datname = 'template1';
SELECT
delete from pg_user where usesysid <> tmp_pguser.datdba;
QUERY: delete from pg_user where usesysid <> tmp_pguser.datdba;
DELETE 0
drop table tmp_pguser;
QUERY: drop table tmp_pguser;
DROP
copy pg_user from stdin;
QUERY: copy pg_user from stdin;
Enter info followed by a newline
End with a backslash and a period on a line by itself.
>>

And then it just stops...?

This is using pg_dump/pg_dumpall from 6.2.1, before shutting down v6.2.1,
to create the db.dump file...

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 1998-03-08 22:59:29 Is it just me...?
Previous Message Bruce Momjian 1998-03-08 19:48:31 Re: [DOCS] Re: pgsql-docs-digest V1 #312