X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 749079DC804 for ; Tue, 14 Feb 2006 17:12:25 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 66936-05 for ; Tue, 14 Feb 2006 17:12:26 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 763D29DC816 for ; Tue, 14 Feb 2006 17:12:23 -0400 (AST) Received: from isb.com.pl (isb.com.pl [212.160.150.140]) by svr4.postgresql.org (Postfix) with ESMTP id 849805AF0B3 for ; Tue, 14 Feb 2006 21:12:25 +0000 (GMT) Received: from 192.168.0.17 (sembrz [192.168.1.50]) by isb.com.pl (Postfix) with ESMTP id 23C6F57842 for ; Tue, 14 Feb 2006 22:08:49 +0100 (CET) Date: Tue, 14 Feb 2006 22:12:18 +0100 From: Maciej Piekielniak X-Mailer: The Bat! (v1.62r) Reply-To: Maciej Piekielniak X-Priority: 3 (Normal) Message-ID: <1827225102.20060214221218@isb.com.pl> To: pgsql-sql@postgresql.org Subject: create table and data types MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200602/154 X-Sequence-Number: 24164 Hello pgsql-sql, Is anybody know how create field in a new table with data type accuiring from a field in other table? For example: create table new_table ( name other_table.name%TYPE ); -- Best regards, Maciej mailto:piechcio@isb.com.pl