Re: create table and data types

Maciej Piekielniak  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