On Tue, 16 Oct 2001 18:42:19 +0100, Allan Engelhardt <[EMAIL PROTECTED]> wrote:
> OK, I'm probably doing something very stupid, but can somebody explain how I'm
>supposed to restore a custom archive dump?
>
> $ createdb foo
> CREATE DATABASE
> $ psql foo
> foo=# create table users (id serial);
>
Oh, no! Please don't tell me I also can't use BLOB in PostgreSQL.
Surely there is a way to backup and restore the *whole* database?
I've tried creating the database manually and then
$ droplang plpgsql foo
before the restore, but that didn't work either. The language is, of
course, c
OK, I'm probably doing something very stupid, but can somebody explain how I'm
supposed to restore a custom archive dump?
$ createdb foo
CREATE DATABASE
$ psql foo
foo=# create table users (id serial);
NOTICE: CREATE TABLE will create implicit sequence 'users_id_seq' for SERIAL column
'users.i
