Home > mailing lists

Insert into when the type is an other table - Mailing list pgsql-general

From	Mourad EL HADJ MIMOUNE
Subject	Insert into when the type is an other table
Date	March 19, 2001 11:43:09
Msg-id	005601c0b07a$be514630$71a337c1@ensma.fr Whole thread Raw
Responses	Re: Insert into when the type is an other table
List	pgsql-general

Hi,

I created a Tables : Create Table address (contry varchar(20), city varchar(20), zip_code integer),

Create Table person (Name varchar(20), addr address);

I would know how I can Insert Values in person table.

note that Postgres add each created table in pg_types catalog table. so, each table is considered as a data type. is this right?

thanks for your help,

Mourad

From: Michelle Murrain
Date: 19 March 2001, 11:25:56
Subject: Re: IDE or RAD tools

From: Ned Lilly
Date: 19 March 2001, 12:12:53
Subject: Re: IDE or RAD tools