[SQL] create table and data types

[Maciej Piekielniak]

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:[EMAIL PROTECTED]


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster