create table and data types

From: Maciej Piekielniak <piechcio(at)isb(dot)com(dot)pl>
To: pgsql-sql(at)postgresql(dot)org
Subject: create table and data types
Date: 2006-02-14 21:12:18
Message-ID: 1827225102.20060214221218@isb.com.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)isb(dot)com(dot)pl

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ken Hill 2006-02-14 21:24:54 Re: Non Matching Records in Two Tables
Previous Message chester c young 2006-02-14 21:08:29 Re: Non Matching Records in Two Tables