Re: create table and data types - Mailing list pgsql-sql

From Tom Lane
Subject Re: create table and data types
Date
Msg-id 23215.1139954794@sss.pgh.pa.us
Whole thread Raw
In response to create table and data types  (Maciej Piekielniak <piechcio@isb.com.pl>)
List pgsql-sql
Maciej Piekielniak <piechcio@isb.com.pl> writes:
>   Is anybody know how create field in a new table with data type accuiring from a field in other table?

Sorry, the %TYPE syntax only works in function declarations at the
moment.

It could possibly be made to work in table declarations --- there are
syntactic conflicts with allowing it in general, but I'm not sure that
objection applies to table declarations.  But it's not there today.
        regards, tom lane


pgsql-sql by date:

Previous
From: Maciej Piekielniak
Date:
Subject: Re: create table and data types
Next
From: Ken Hill
Date:
Subject: Re: create table and data types