Composite type

Hello guys!

I have found a example in Oracle and I am trying to do it in Postgre.

Lets say that we have 2 tables.
Create Table "table1" Of "type1"
Create Table "table2" Of "type2"

I want to refer the first table in the second. I want to reference the whole
table not only one field, so something like that:

CREATE TYPE type2 AS OBJECT (
var1 NUMBER,
var2 REF type1
)

CREATE TABLE table2 OF type2 (
PRIMARY KEY (Pk),
FOREIGN KEY (fk) REFERENCES table1)

Can i do something like this in Postgre?

Thank you in advance!
George Ant

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Composite-type-tp5788860.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.