Re: [HACKERS] pg_dump file question

2002-10-08 Thread Neil Conway
Robert Partyka <[EMAIL PROTECTED]> writes: > \connect template1 > . > CREATE USER "foo" WITH SYSID 32 PASSWORD 'bar' NOCREATEDB NOCREATEUSER; > . > \connect template1 "foo" > CREATE DATABASE "foodb" WITH TEMPLATE = template0 ENCODING = 'LATIN2'; > \connect "foodb" "foo" > > I think evryon

[HACKERS] pg_dump file question

2002-10-08 Thread Robert Partyka
Hi, My friend just notice me with some thing that make using dump files harder to use. So here we go: first we make some chaos :) \c template1 postgres create user foo with password 'bar' createdb nocreateuser; \c template1 foo create database foodb; \c template1 postgres alter user foo with no