← Back to branch summary

~ubuntu-branches/ubuntu/oneiric/postgresql-9.1/oneiric-updates

« back to all changes in this revision

Viewing changes to doc/src/sgml/html/infoschema-element-types.html

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2011-06-14 09:53:29 UTC
  • mfrom: (1.1.1 upstream)
  • Revision ID: james.westby@ubuntu.com-20110614095329-kerawur7tb6p8s71
Tags: 9.1~beta2-1
* New upstream beta release.
* Drop 03-cmsgcred-size.patch, fixed upstream.
* debian/postgresql-9.1.install: Install new pg_basebackup translations.
* debian/control: Fix the server-dev dependency to p-common to also work for
  backports.
* debian/watch: Fix for beta versions.
* debian/copyright: Add pointers to GPL and Artistic licenses for the Perl
  terms.
* debian/postgresql-9.1.preinst: Fail the package upgrade early when
  upgrading from beta-1, as the DB format changed.

Show diffs side-by-side

added added

removed removed

Lines of Context:
doc/src/sgml/html/infoschema-element-types.html
9
9
REV="MADE"
10
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
11
11
REL="HOME"
12
 
TITLE="PostgreSQL 9.1beta1 Documentation"
 
12
TITLE="PostgreSQL 9.1beta2 Documentation"
13
13
HREF="index.html"><LINK
14
14
REL="UP"
15
15
TITLE="The Information Schema"
26
26
HTTP-EQUIV="Content-Type"
27
27
CONTENT="text/html; charset=ISO-8859-1"><META
28
28
NAME="creation"
29
 
CONTENT="2011-04-27T21:20:33"></HEAD
 
29
CONTENT="2011-06-09T23:44:43"></HEAD
30
30
><BODY
31
31
CLASS="SECT1"
32
32
><DIV
44
44
VALIGN="bottom"
45
45
><A
46
46
HREF="index.html"
47
 
>PostgreSQL 9.1beta1 Documentation</A
 
47
>PostgreSQL 9.1beta2 Documentation</A
48
48
></TH
49
49
></TR
50
50
><TR
131
131
>SELECT c.column_name, c.data_type, e.data_type AS element_type
132
132
FROM information_schema.columns c LEFT JOIN information_schema.element_types e
133
133
     ON ((c.table_catalog, c.table_schema, c.table_name, 'TABLE', c.dtd_identifier)
134
 
       = (e.object_catalog, e.object_schema, e.object_name, e.object_type, e.dtd_identifier))
 
134
       = (e.object_catalog, e.object_schema, e.object_name, e.object_type, e.collection_type_identifier))
135
135
WHERE c.table_schema = '...' AND c.table_name = '...'
136
136
ORDER BY c.ordinal_position;</PRE
137
137
><P>
243
243
><TD
244
244
><TT
245
245
CLASS="LITERAL"
246
 
>dtd_identifier</TT
 
246
>collection_type_identifier</TT
247
247
></TD
248
248
><TD
249
249
><TT
252
252
></TD
253
253
><TD
254
254
>       The identifier of the data type descriptor of the array being
255
 
       described
 
255
       described.  Use this to join with the
 
256
       <TT
 
257
CLASS="LITERAL"
 
258
>dtd_identifier</TT
 
259
> columns of other information
 
260
       schema views.
256
261
      </TD
257
262
></TR
258
263
><TR
646
651
>PostgreSQL</SPAN
647
652
></TD
648
653
></TR
 
654
><TR
 
655
><TD
 
656
><TT
 
657
CLASS="LITERAL"
 
658
>dtd_identifier</TT
 
659
></TD
 
660
><TD
 
661
><TT
 
662
CLASS="TYPE"
 
663
>sql_identifier</TT
 
664
></TD
 
665
><TD
 
666
>       An identifier of the data type descriptor of the element.  This
 
667
       is currently not useful.
 
668
      </TD
 
669
></TR
649
670
></TBODY
650
671
></TABLE
651
672
></DIV