dump and restore in pgadmin

Does pgadmin have support for dumping and restoring a database?
>From pgadmin-support-owner(at)postgresql(dot)org Mon Oct 27 00:30:50 2003
X-Original-To: pgadmin-support-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (unknown [200.46.204.2])
by svr1.postgresql.org (Postfix) with ESMTP id 3BA5ED1B50A
for <pgadmin-support-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Mon, 27 Oct 2003 04:30:46 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
with ESMTP id 64606-08
for <pgadmin-support-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Mon, 27 Oct 2003 00:30:15 -0400 (AST)
Received: from houston.familyhealth.com.au (fhnet.arach.net.au [203.22.197.21])
by svr1.postgresql.org (Postfix) with ESMTP id EA6F3D1B4F4
for <pgadmin-support(at)postgresql(dot)org>; Mon, 27 Oct 2003 00:30:12 -0400 (AST)
Received: from familyhealth.com.au (work-40.internal [192.168.0.40])
by houston.familyhealth.com.au (8.12.9p1/8.12.9) with ESMTP id h9R4U8oD047757;
Mon, 27 Oct 2003 12:30:08 +0800 (WST)
(envelope-from chriskl(at)familyhealth(dot)com(dot)au)
Message-ID: <3F9C9F87(dot)2010203(at)familyhealth(dot)com(dot)au>
Date: Mon, 27 Oct 2003 12:31:03 +0800
From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.5) Gecko/20031013 Thunderbird/0.3
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgadmin(at)claymccoy(dot)com
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: How to use the SET data type? Help plz!
References: <31291190(dot)1067228165006(dot)JavaMail(dot)pgadmin(at)claymccoy(dot)com>
In-Reply-To: <31291190(dot)1067228165006(dot)JavaMail(dot)pgadmin(at)claymccoy(dot)com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/197
X-Sequence-Number: 2324

> Odd that it is a selectable datatype in pgadmin then huh?

That's a question for the pgAdmin guys, but I know that PostgreSQL has a
type called 'set', which is nothing to do with sets as you understand
them.

> If there are no sets, then is there anythign else that can be used to
> represent that type of data. I used them a lot in a mySQL database that I am
> migrating from. It is very useful to have a predefined set of values to
> choose from, otherwise it would just be a text field with no constraints as to
> the contents. It is also nice to have the popup menus of the selecable values
> when inputing data like how phpmyadmin handles sets. It seem slike a huge
> oversight to not support them.

Look up CHECK constraints.

Lack of 'MySQL sets' in Postgres is NOT an oversight. It's a random,
non-SQL standard type that the MySQL developers made up one day that no
other database on Earth supports. Why should Postgres support it? It's
just a lame workaround for MySQL not supporting constraints.

(Sorry to sound all worked up about it, but it's one of the things I
find annoying about MySQL...)

Chris