Skip site navigation (1) Skip section navigation (2)

use of a composite type in CREATE TABLE?

From: Hannes Korte <email(at)hkorte(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: use of a composite type in CREATE TABLE?
Date: 2004-06-17 11:01:08
Message-ID: 40D179F4.3090901@hkorte.com (view raw or flat)
Thread:
Lists: pgsql-sql
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

Responses

pgsql-sql by date

Next:From: Richard HuxtonDate: 2004-06-17 13:36:34
Subject: Re: Optimal query suggestion needed
Previous:From: Kris JurkaDate: 2004-06-17 04:30:03
Subject: Re: Prepare Statement

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group