Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f55JOSE58526 for ; Tue, 5 Jun 2001 15:24:28 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4U9SDE75073 for ; Wed, 30 May 2001 05:28:13 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f4U9GOV49660 for pgsql-sql@postgresql.org; Wed, 30 May 2001 05:16:24 -0400 (EDT) (envelope-from news) From: =?iso-8859-1?Q?Hans=2DJ=FCrgen=20Sch=F6nig?= X-Newsgroups: comp.databases.postgresql.sql Subject: Re: How to use the template table in postgresql Date: Wed, 30 May 2001 11:15:32 +0200 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 29 Message-ID: <3B14BA34.C9E637DA@cybertec.at> References: <9f2cnp$1g97$1@news.tht.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: scrappy@hub.org X-Mailer: Mozilla 4.77 [de] (X11; U; Linux 2.4.2-2 i686) X-Accept-Language: en To: pgsql-sql@postgresql.org X-Archive-Number: 200106/40 X-Sequence-Number: 3243 stone schrieb: > Hello: > I'm new user of postgresql. My problem is that: > 1. How to create template table? Is it right of ' Create temptable > test(......)'? > 2.My application is Client/Server, can I has some workstations create the > same template table name on the same time? If I could, How can I do with it? > Thanks for your help. Stone. If you want to find out more about the syntax of a command you can use \h as shown below: myodbc=# \h create table Command: CREATE TABLE Description: Creates a new table Syntax: CREATE [ TEMPORARY | TEMP ] TABLE table_name ( { column_name type [ column_constraint [ ... ] ] | table_constraint } [, ... ] ) [ INHERITS ( parent_table [, ... ] ) ] Temporary tables are only visible for the user who created the table - you need not worry that something evil happens. A temporary table is killed as soon as the session is closed. Hans