Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 203761337B47 for ; Wed, 29 Sep 2010 03:43:35 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 28306-08 for ; Wed, 29 Sep 2010 06:43:27 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-fx0-f46.google.com (mail-fx0-f46.google.com [209.85.161.46]) by mail.postgresql.org (Postfix) with ESMTP id 641441337B2F for ; Wed, 29 Sep 2010 03:43:27 -0300 (ADT) Received: by fxm14 with SMTP id 14so267964fxm.19 for ; Tue, 28 Sep 2010 23:43:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:from:to:subject:date :message-id:mime-version:content-type:x-mailer:content-language :thread-index; bh=i2vptvO6+SnxqKw5tByYrAYixZdV06g60bq5rTsbzbI=; b=Qn2ZW7tX7PU7A6jHcz11W4zfJ9mD3DXDItRfHPS0pYTu5GPLMM3bCKyrxlil7ZEXOA GKYyP63JpSlR1Upairensr2QkEy/w3IWlaQHhYUc+V+hb4usg+2K6UTbu6xxv9ooD8ZG 4TbBkhfVMY2kiT/KMYsu9CI3ALSLDyJYARF9Y= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=from:to:subject:date:message-id:mime-version:content-type:x-mailer :content-language:thread-index; b=kPOmAlbsJk1Acg7XF1gwdfi78JIP+sBFXTGnURx6VkXXseVRDbBwmrj8YkIioQLOfI X05Nycr+pcPTm29qYl77JLHU9JH2T3fc6VHEWeCA3KZPK54PZ6k9DTyYvZIsDVOZc59b +bIWRE7z6v1t7p89oNcdqLJ+mp+zzkKcIcARQ= Received: by 10.223.97.136 with SMTP id l8mr927101fan.89.1285742606594; Tue, 28 Sep 2010 23:43:26 -0700 (PDT) Received: from CPLW09 ([81.201.194.78]) by mx.google.com with ESMTPS id j14sm3596989faa.47.2010.09.28.23.43.24 (version=TLSv1/SSLv3 cipher=RC4-MD5); Tue, 28 Sep 2010 23:43:25 -0700 (PDT) From: "Thomas Andres" To: Subject: Shema with template Date: Wed, 29 Sep 2010 08:42:42 +0200 Message-ID: <000001cb5fa1$8534e240$8f9ea6c0$@com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0001_01CB5FB2.48BDB240" X-Mailer: Microsoft Office Outlook 12.0 Content-Language: de-ch Thread-Index: ActfoYQn6ZGg6g+mTp6SxsCxTIKy5Q== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=-5 required=5 tests=BAYES_40=-0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201009/112 X-Sequence-Number: 34643 This is a multi-part message in MIME format. ------=_NextPart_000_0001_01CB5FB2.48BDB240 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear List, =20 I have created a database with the template postgis. =20 In this database a shema named =91public=92 was created, with the = functions of postgis and two tables (geometry_columns and spatial_ref_sys). =20 Now, I would like to create one shema like this for every village. How can I add a shema to a existing database by using a template? =20 Thank you for your help. =20 Salutation from Switzerland Andres Thomas z=92Chuchich=E4schtli =20 =20 ------=_NextPart_000_0001_01CB5FB2.48BDB240 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Dear List,

I have created a database with = the template postgis.

In this database a shema named = ‘public’ was created, with the functions of postgis and two tables = (geometry_columns and spatial_ref_sys).

Now, I would like to create one = shema like this for every village.

How can I add a shema to a = existing database by using a template?

Thank you for your = help.

Salutation from Switzerland

Andres Thomas

z’Chuchichäschtli

------=_NextPart_000_0001_01CB5FB2.48BDB240--