Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.postgresql > #294 > unrolled thread
| Started by | Don Y <this@isnotme.com> |
|---|---|
| First post | 2012-01-31 08:43 -0700 |
| Last post | 2012-02-08 01:18 -0700 |
| Articles | 5 — 3 participants |
Back to article view | Back to comp.databases.postgresql
Teasing a type definition from system tables Don Y <this@isnotme.com> - 2012-01-31 08:43 -0700
Re: Teasing a type definition from system tables Username <someone@invalid.tld> - 2012-02-02 00:41 +0100
Re: Teasing a type definition from system tables Don Y <this@isnotme.com> - 2012-02-05 03:18 -0700
Re: Teasing a type definition from system tables Jasen Betts <jasen@xnet.co.nz> - 2012-02-03 10:47 +0000
Re: Teasing a type definition from system tables Don Y <this@isnotme.com> - 2012-02-08 01:18 -0700
| From | Don Y <this@isnotme.com> |
|---|---|
| Date | 2012-01-31 08:43 -0700 |
| Subject | Teasing a type definition from system tables |
| Message-ID | <jg9265$9t4$1@speranza.aioe.org> |
Hi, For "non-standard" types (e.g., composite, user-defined), is there any way of teasing the definition out of the system catalog? E.g., CREATE TYPE foo AS ( control1 point, control2 point, dest point ); CREATE TYPE bar AS ( purpose text, action foo, when date ); It seems like type definitions fall into a black hole... Thx, --don
[toc] | [next] | [standalone]
| From | Username <someone@invalid.tld> |
|---|---|
| Date | 2012-02-02 00:41 +0100 |
| Message-ID | <jgciiv$jpr$1@gazette.hrz.tu-chemnitz.de> |
| In reply to | #294 |
Hi Don, > For "non-standard" types (e.g., composite, user-defined), is there > any way of teasing the definition out of the system catalog? Have a look at MogwaiERDesignerNG and its reverseengineering capabilities: http://sourceforge.net/projects/mogwai/ The way it is done you can find in http://mogwai.svn.sourceforge.net/viewvc/mogwai/trunk/mogwai/MogwaiERDesignerNG/src/main/java/de/erdesignerng/dialect/postgres/PostgresReverseEngineeringStrategy.java?revision=1422&view=markup in the lines 194 for enumerations, 233 for composite types 312 for external types (not implemented yet) HTH regards
[toc] | [prev] | [next] | [standalone]
| From | Don Y <this@isnotme.com> |
|---|---|
| Date | 2012-02-05 03:18 -0700 |
| Message-ID | <jgll13$fij$1@speranza.aioe.org> |
| In reply to | #295 |
On 2/1/2012 4:41 PM, Username wrote: > Hi Don, > >> For "non-standard" types (e.g., composite, user-defined), is there >> any way of teasing the definition out of the system catalog? > > Have a look at MogwaiERDesignerNG and its reverseengineering > capabilities: http://sourceforge.net/projects/mogwai/ > > The way it is done you can find in > in the lines > > 194 for enumerations, > 233 for composite types > 312 for external types (not implemented yet) Excellent! I may actually look into using the tool, itself. Thanks!
[toc] | [prev] | [next] | [standalone]
| From | Jasen Betts <jasen@xnet.co.nz> |
|---|---|
| Date | 2012-02-03 10:47 +0000 |
| Message-ID | <jggdvd$9u$3@reversiblemaps.ath.cx> |
| In reply to | #294 |
On 2012-01-31, Don Y <this@isnotme.com> wrote: > Hi, > > For "non-standard" types (e.g., composite, user-defined), is there > any way of teasing the definition out of the system catalog? > see how psql does it: psql -E \d bar -- ⚂⚃ 100% natural --- Posted via news://freenews.netfront.net/ - Complaints to news@netfront.net ---
[toc] | [prev] | [next] | [standalone]
| From | Don Y <this@isnotme.com> |
|---|---|
| Date | 2012-02-08 01:18 -0700 |
| Message-ID | <jgtb4m$1md$1@speranza.aioe.org> |
| In reply to | #296 |
Hi Jasen, On 2/3/2012 3:47 AM, Jasen Betts wrote: > On 2012-01-31, Don Y<this@isnotme.com> wrote: >> For "non-standard" types (e.g., composite, user-defined), is there >> any way of teasing the definition out of the system catalog? >> > > see how psql does it: > > psql -E > \d bar Thanks! I'll try that next time I am logged onto the server.
[toc] | [prev] | [standalone]
Back to top | Article view | comp.databases.postgresql
csiph-web