Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 31C9C633209 for ; Sun, 29 Mar 2009 23:40:36 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 12396-03 for ; Sun, 29 Mar 2009 23:40:24 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.230]) by mail.postgresql.org (Postfix) with ESMTP id 70A0D63219E for ; Sun, 29 Mar 2009 23:40:33 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id l9so2513052rvb.43 for ; Sun, 29 Mar 2009 19:40:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type:content-transfer-encoding; bh=2L9YrrU9c0DF/WrxJbQJjnhl0p1a3ONTNSpMC7/AL6Q=; b=drBo/f+Gj9OXHEQAdm2G/5IjfCf2oVJGr5a1A5Xx4T8q5lTyXij3AKRZpSQoLltFe5 re1lX+agMDTjMkorFnhmrw6orKmRnPlj0Upa6vO07QmNOib5WuJbCL0dYhw9XnSDpxgF Gh01Fv/cAZ+E6m012+DR1SMelairqMBkhNlBY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type :content-transfer-encoding; b=qLcQdrrq318yx0Kh6qnfNfZaQA6hzmNUM5ukL7B3jZ1rhKMS3mOigC74zRZWG007Dc Qh/P9PnhAhokSDDcI+MQ8TsxlqMrkqqjMndeMD4/nf2+pGkNCfX4xY76/4w6LPfuvMsL MYNzvCQnCFTP9XGucUsZs65WKVrVXlkRm+pG0= MIME-Version: 1.0 Received: by 10.141.180.5 with SMTP id h5mr2551129rvp.51.1238380829478; Sun, 29 Mar 2009 19:40:29 -0700 (PDT) Date: Mon, 30 Mar 2009 13:40:29 +1100 Message-ID: <131b56be0903291940j4c726abcgc0ae79a3d458fbec@mail.gmail.com> Subject: forgot the structure of a composite type From: Manal Helal To: pgsql-admin@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/244 X-Sequence-Number: 31744 Hi I defined a composite type and forgot its structure, data fields names and data types. Is there any command that can define that for me? or a table where I can find this information stored to retrieve it back, sorry if its a basic question, but it is my first time with composite types and didn't keep enough documentation while just starting, thank you very much, Kind Regards, Manal