Postgres Pro
Downloads
Home   >   mailing lists

use of a composite type in CREATE TABLE? - Mailing list pgsql-sql

From Hannes Korte
Subject use of a composite type in CREATE TABLE?
Date
Msg-id 40D179F4.3090901@hkorte.com
Whole thread Raw
Responses Re: use of a composite type in CREATE TABLE?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: use of a composite type in CREATE TABLE?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-sql
Tree view 
Hi,

does anyone know how it is posible to set a composite type as the data 
type of a column when creating a new table?

CREATE TABLE tbl1 (
name VARCHAR(60) NOT NULL,
address comp_type_address
);

The exmaple above does not work.
Any help is appreciated.

-- 
Regards,
Hannes

pgsql-sql by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: Is there a faster way to do this?
Next
From: Interzone
Date:
Subject: Optimal query suggestion needed