1# SOME DESCRIPTIVE TITLE. 2# 3# Translators: 4# geojs, 2014 5# geojs, 2014 6# Nicolas Ribot <nicolas.ribot@gmail.com>, 2013 7# Vincent Picavet <vincent.ml@oslandia.com>, 2016 8msgid "" 9msgstr "" 10"Project-Id-Version: PostGIS\n" 11"Report-Msgid-Bugs-To: http://bugs.kde.org\n" 12"POT-Creation-Date: 2018-07-21 17:36+0000\n" 13"PO-Revision-Date: 2018-07-22 03:14+0000\n" 14"Last-Translator: georgersilva <georger.silva@gmail.com>\n" 15"Language-Team: French (http://www.transifex.com/postgis/postgis/language/" 16"fr/)\n" 17"Language: fr\n" 18"MIME-Version: 1.0\n" 19"Content-Type: text/plain; charset=UTF-8\n" 20"Content-Transfer-Encoding: 8bit\n" 21"Plural-Forms: nplurals=2; plural=(n > 1);\n" 22 23#. Tag: title 24#: reference_management.xml:3 25#, no-c-format 26msgid "Management Functions" 27msgstr "Fonctions de gestion" 28 29#. Tag: refname 30#: reference_management.xml:7 31#, no-c-format 32msgid "AddGeometryColumn" 33msgstr "AddGeometryColumn" 34 35#. Tag: refpurpose 36#: reference_management.xml:9 37#, no-c-format 38msgid "" 39"Adds a geometry column to an existing table of attributes. By default uses " 40"type modifier to define rather than constraints. Pass in false for " 41"use_typmod to get old check constraint based behavior" 42msgstr "" 43"Ajoute une colonne géométrique à une table attributaire existante. Utilise " 44"par défaut le modificateur de type lors de la définition de la géométrie, " 45"plutôt que des contraintes. Passer le paramètre use_typmod à false pour " 46"activer l'ancien mécanisme basé sur les contraintes." 47 48#. Tag: funcsynopsis 49#: reference_management.xml:15 50#, no-c-format 51msgid "" 52"<funcprototype> <funcdef>text <function>AddGeometryColumn</function></" 53"funcdef> <paramdef><type>varchar </type> <parameter>table_name</parameter></" 54"paramdef> <paramdef><type>varchar </type> <parameter>column_name</" 55"parameter></paramdef> <paramdef><type>integer </type> <parameter>srid</" 56"parameter></paramdef> <paramdef><type>varchar </type> <parameter>type</" 57"parameter></paramdef> <paramdef><type>integer </type> <parameter>dimension</" 58"parameter></paramdef> <paramdef choice=\"opt\"><type>boolean </type> " 59"<parameter>use_typmod=true</parameter></paramdef> </funcprototype> " 60"<funcprototype> <funcdef>text <function>AddGeometryColumn</function></" 61"funcdef> <paramdef><type>varchar </type> <parameter>schema_name</parameter></" 62"paramdef> <paramdef><type>varchar </type> <parameter>table_name</parameter></" 63"paramdef> <paramdef><type>varchar </type> <parameter>column_name</" 64"parameter></paramdef> <paramdef><type>integer </type> <parameter>srid</" 65"parameter></paramdef> <paramdef><type>varchar </type> <parameter>type</" 66"parameter></paramdef> <paramdef><type>integer </type> <parameter>dimension</" 67"parameter></paramdef> <paramdef choice=\"opt\"><type>boolean </type> " 68"<parameter>use_typmod=true</parameter></paramdef> </funcprototype> " 69"<funcprototype> <funcdef>text <function>AddGeometryColumn</function></" 70"funcdef> <paramdef><type>varchar </type> <parameter>catalog_name</" 71"parameter></paramdef> <paramdef><type>varchar </type> " 72"<parameter>schema_name</parameter></paramdef> <paramdef><type>varchar </" 73"type> <parameter>table_name</parameter></paramdef> <paramdef><type>varchar </" 74"type> <parameter>column_name</parameter></paramdef> <paramdef><type>integer " 75"</type> <parameter>srid</parameter></paramdef> <paramdef><type>varchar </" 76"type> <parameter>type</parameter></paramdef> <paramdef><type>integer </type> " 77"<parameter>dimension</parameter></paramdef> <paramdef choice=\"opt" 78"\"><type>boolean </type> <parameter>use_typmod=true</parameter></paramdef> </" 79"funcprototype>" 80msgstr "" 81"<funcprototype> <funcdef>text <function>AddGeometryColumn</function></" 82"funcdef> <paramdef><type>varchar </type> <parameter>table_name</parameter></" 83"paramdef> <paramdef><type>varchar </type> <parameter>column_name</" 84"parameter></paramdef> <paramdef><type>integer </type> <parameter>srid</" 85"parameter></paramdef> <paramdef><type>varchar </type> <parameter>type</" 86"parameter></paramdef> <paramdef><type>integer </type> <parameter>dimension</" 87"parameter></paramdef> <paramdef choice=\"opt\"><type>boolean </type> " 88"<parameter>use_typmod=true</parameter></paramdef> </funcprototype> " 89"<funcprototype> <funcdef>text <function>AddGeometryColumn</function></" 90"funcdef> <paramdef><type>varchar </type> <parameter>schema_name</parameter></" 91"paramdef> <paramdef><type>varchar </type> <parameter>table_name</parameter></" 92"paramdef> <paramdef><type>varchar </type> <parameter>column_name</" 93"parameter></paramdef> <paramdef><type>integer </type> <parameter>srid</" 94"parameter></paramdef> <paramdef><type>varchar </type> <parameter>type</" 95"parameter></paramdef> <paramdef><type>integer </type> <parameter>dimension</" 96"parameter></paramdef> <paramdef choice=\"opt\"><type>boolean </type> " 97"<parameter>use_typmod=true</parameter></paramdef> </funcprototype> " 98"<funcprototype> <funcdef>text <function>AddGeometryColumn</function></" 99"funcdef> <paramdef><type>varchar </type> <parameter>catalog_name</" 100"parameter></paramdef> <paramdef><type>varchar </type> " 101"<parameter>schema_name</parameter></paramdef> <paramdef><type>varchar </" 102"type> <parameter>table_name</parameter></paramdef> <paramdef><type>varchar </" 103"type> <parameter>column_name</parameter></paramdef> <paramdef><type>integer " 104"</type> <parameter>srid</parameter></paramdef> <paramdef><type>varchar </" 105"type> <parameter>type</parameter></paramdef> <paramdef><type>integer </type> " 106"<parameter>dimension</parameter></paramdef> <paramdef choice=\"opt" 107"\"><type>boolean </type> <parameter>use_typmod=true</parameter></paramdef> </" 108"funcprototype>" 109 110#. Tag: title 111#: reference_management.xml:92 reference_management.xml:188 112#: reference_management.xml:254 reference_management.xml:298 113#: reference_management.xml:351 reference_management.xml:397 114#: reference_management.xml:439 reference_management.xml:480 115#: reference_management.xml:521 reference_management.xml:552 116#: reference_management.xml:593 reference_management.xml:634 117#: reference_management.xml:677 reference_management.xml:725 118#: reference_management.xml:771 reference_management.xml:820 119#: reference_management.xml:957 120#, no-c-format 121msgid "Description" 122msgstr "Description" 123 124#. Tag: para 125#: reference_management.xml:94 126#, no-c-format 127msgid "" 128"Adds a geometry column to an existing table of attributes. The " 129"<varname>schema_name</varname> is the name of the table schema. The " 130"<varname>srid</varname> must be an integer value reference to an entry in " 131"the SPATIAL_REF_SYS table. The <varname>type</varname> must be a string " 132"corresponding to the geometry type, eg, 'POLYGON' or 'MULTILINESTRING' . An " 133"error is thrown if the schemaname doesn't exist (or not visible in the " 134"current search_path) or the specified SRID, geometry type, or dimension is " 135"invalid." 136msgstr "" 137"Ajoute une colonne géométrique à une table attributaire existante. " 138"<varname>schema_name</varname> est le nom du schéma de la table.\n" 139"<varname>srid</varname> est un entier positif présent dans la table " 140"SPATIAL_REF_SYS. <varname>type</varname> est le type de géométrie en texte, " 141"par exemple 'POLYGON' ou 'MULTILINESTRING'. Une erreur est renvoyée si le " 142"schéma n'existe pas (ou n'est pas visible dans le search_path courant) ou si " 143"le SRID, type de géométrie ou dimension est invalide." 144 145#. Tag: para 146#: reference_management.xml:104 147#, no-c-format 148msgid "" 149"Changed: 2.0.0 This function no longer updates geometry_columns since " 150"geometry_columns is a view that reads from system catalogs. It by default " 151"also does not create constraints, but instead uses the built in type " 152"modifier behavior of PostgreSQL. So for example building a wgs84 POINT " 153"column with this function is now equivalent to: <code>ALTER TABLE some_table " 154"ADD COLUMN geom geometry(Point,4326);</code>" 155msgstr "" 156"Changement: 2.0.0 Cette fonction ne met plus à jour geometry_columns " 157"maintenant que geometry_columns est une vue basée sur le catalogue système. " 158"Par défaut, elle ne créée plus de contraintes mais utilise le modificateur " 159"de type de PostgreSQL. Ainsi, par exemple, créer une colonne de type POINT " 160"WGS84 est désormais équivalent à: <code>ALTER TABLE some_table ADD COLUMN " 161"geom geometry(Point,4326);</code>" 162 163#. Tag: para 164#: reference_management.xml:107 165#, no-c-format 166msgid "" 167"Changed: 2.0.0 If you require the old behavior of constraints use the " 168"default <varname>use_typmod</varname>, but set it to false." 169msgstr "" 170"Changement: 2.0.0 Si l'ancien mécanisme basé sur les contraintes est " 171"nécessaire, utiliser le paramètre <varname>use_typmod</varname> avec la " 172"valeur false." 173 174#. Tag: para 175#: reference_management.xml:111 176#, no-c-format 177msgid "" 178"Changed: 2.0.0 Views can no longer be manually registered in " 179"geometry_columns, however views built against geometry typmod tables " 180"geometries and used without wrapper functions will register themselves " 181"correctly because they inherit the typmod behavior of their parent table " 182"column. Views that use geometry functions that output other geometries will " 183"need to be cast to typmod geometries for these view geometry columns to be " 184"registered correctly in geometry_columns. Refer to <xref linkend=" 185"\"Manual_Register_Spatial_Column\"/>." 186msgstr "" 187"Changement: 2.0.0 Les vues ne peuvent plus être enregistrées dans " 188"geometry_columns. Cependant, les vues construites à partir de tables " 189"contenant des géométries définies avec le modificateur de type et " 190"n'utilisant pas de fonctions d'encapsulation seront enregistrées dans la vue " 191"geometry_columns car elles héritent du mécanisme des tables dont elles sont " 192"issues. Les vues utilisant des fonctions renvoyant d'autres géométries " 193"doivent être transtypées vers des géométries avec modificateur de type pour " 194"pouvoir être correctement référencées dans la vue geometry_columns. Cf. " 195"<xref linkend=\"Manual_Register_Spatial_Column\"/>." 196 197#. Tag: para 198#: reference_management.xml:117 reference_management.xml:194 199#, no-c-format 200msgid "&sfs_compliant;" 201msgstr "&sfs_compliant;" 202 203#. Tag: para 204#: reference_management.xml:118 reference_management.xml:195 205#: reference_management.xml:963 206#, no-c-format 207msgid "&Z_support;" 208msgstr "&Z_support;" 209 210#. Tag: para 211#: reference_management.xml:119 reference_management.xml:196 212#: reference_management.xml:964 213#, no-c-format 214msgid "&curve_support;" 215msgstr "&curve_support;" 216 217#. Tag: para 218#: reference_management.xml:120 219#, no-c-format 220msgid "" 221"Enhanced: 2.0.0 use_typmod argument introduced. Defaults to creating typmod " 222"geometry column instead of constraint-based." 223msgstr "" 224"Amélioration: 2.0.0 introduction du paramètre use_typmod. Le comportement " 225"par défaut est de créer une colonne géométrique avec modificateur de type au " 226"lieu de contraintes sur la colonne." 227 228#. Tag: title 229#: reference_management.xml:124 reference_management.xml:203 230#: reference_management.xml:267 reference_management.xml:310 231#: reference_management.xml:359 reference_management.xml:404 232#: reference_management.xml:445 reference_management.xml:487 233#: reference_management.xml:527 reference_management.xml:558 234#: reference_management.xml:600 reference_management.xml:642 235#: reference_management.xml:694 reference_management.xml:740 236#: reference_management.xml:777 reference_management.xml:878 237#: reference_management.xml:967 238#, no-c-format 239msgid "Examples" 240msgstr "Exemples" 241 242#. Tag: programlisting 243#: reference_management.xml:126 244#, no-c-format 245msgid "" 246"-- Create schema to hold data\n" 247"CREATE SCHEMA my_schema;\n" 248"-- Create a new simple PostgreSQL table\n" 249"CREATE TABLE my_schema.my_spatial_table (id serial);\n" 250"\n" 251"-- Describing the table shows a simple table with a single \"id\" column.\n" 252"postgis=# \\d my_schema.my_spatial_table\n" 253" Table \"my_schema." 254"my_spatial_table\"\n" 255" Column | Type | Modifiers\n" 256"--------+---------" 257"+-------------------------------------------------------------------------\n" 258" id | integer | not null default nextval('my_schema." 259"my_spatial_table_id_seq'::regclass)\n" 260"\n" 261"-- Add a spatial column to the table\n" 262"SELECT AddGeometryColumn " 263"('my_schema','my_spatial_table','geom',4326,'POINT',2);\n" 264"\n" 265"-- Add a point using the old constraint based behavior\n" 266"SELECT AddGeometryColumn " 267"('my_schema','my_spatial_table','geom_c',4326,'POINT',2, false);\n" 268"\n" 269"--Add a curvepolygon using old constraint behavior\n" 270"SELECT AddGeometryColumn " 271"('my_schema','my_spatial_table','geomcp_c',4326,'CURVEPOLYGON',2, false);\n" 272"\n" 273"-- Describe the table again reveals the addition of a new geometry columns.\n" 274"\\d my_schema.my_spatial_table\n" 275" addgeometrycolumn\n" 276"-------------------------------------------------------------------------\n" 277" my_schema.my_spatial_table.geomcp_c SRID:4326 TYPE:CURVEPOLYGON DIMS:2\n" 278"(1 row)\n" 279"\n" 280" Table \"my_schema.my_spatial_table\"\n" 281" Column | Type | Modifiers\n" 282"----------+----------------------" 283"+-------------------------------------------------------------------------\n" 284" id | integer | not null default nextval('my_schema." 285"my_spatial_table_id_seq'::regclass)\n" 286" geom | geometry(Point,4326) |\n" 287" geom_c | geometry |\n" 288" geomcp_c | geometry |\n" 289"Check constraints:\n" 290" \"enforce_dims_geom_c\" CHECK (st_ndims(geom_c) = 2)\n" 291" \"enforce_dims_geomcp_c\" CHECK (st_ndims(geomcp_c) = 2)\n" 292" \"enforce_geotype_geom_c\" CHECK (geometrytype(geom_c) = 'POINT'::text " 293"OR geom_c IS NULL)\n" 294" \"enforce_geotype_geomcp_c\" CHECK (geometrytype(geomcp_c) = " 295"'CURVEPOLYGON'::text OR geomcp_c IS NULL)\n" 296" \"enforce_srid_geom_c\" CHECK (st_srid(geom_c) = 4326)\n" 297" \"enforce_srid_geomcp_c\" CHECK (st_srid(geomcp_c) = 4326)\n" 298"\n" 299"-- geometry_columns view also registers the new columns --\n" 300"SELECT f_geometry_column As col_name, type, srid, coord_dimension As ndims\n" 301" FROM geometry_columns\n" 302" WHERE f_table_name = 'my_spatial_table' AND f_table_schema = " 303"'my_schema';\n" 304"\n" 305" col_name | type | srid | ndims\n" 306"----------+--------------+------+-------\n" 307" geom | Point | 4326 | 2\n" 308" geom_c | Point | 4326 | 2\n" 309" geomcp_c | CurvePolygon | 4326 | 2" 310msgstr "" 311 312#. Tag: title 313#: reference_management.xml:130 reference_management.xml:208 314#: reference_management.xml:272 reference_management.xml:317 315#: reference_management.xml:365 reference_management.xml:410 316#: reference_management.xml:451 reference_management.xml:493 317#: reference_management.xml:564 reference_management.xml:606 318#: reference_management.xml:648 reference_management.xml:700 319#: reference_management.xml:746 reference_management.xml:783 320#: reference_management.xml:980 321#, no-c-format 322msgid "See Also" 323msgstr "Voir aussi" 324 325#. Tag: para 326#: reference_management.xml:132 327#, no-c-format 328msgid "" 329", <xref linkend=\"DropGeometryTable\"/>, <xref linkend=\"geometry_columns\"/" 330">, <xref linkend=\"Manual_Register_Spatial_Column\"/>" 331msgstr "" 332", <xref linkend=\"DropGeometryTable\"/>, <xref linkend=\"geometry_columns\"/" 333">, <xref linkend=\"Manual_Register_Spatial_Column\"/>" 334 335#. Tag: refname 336#: reference_management.xml:138 337#, no-c-format 338msgid "DropGeometryColumn" 339msgstr "DropGeometryColumn" 340 341#. Tag: refpurpose 342#: reference_management.xml:140 343#, no-c-format 344msgid "Removes a geometry column from a spatial table." 345msgstr "Supprime une colonne géométrique d'une table spatiale." 346 347#. Tag: funcsynopsis 348#: reference_management.xml:145 349#, no-c-format 350msgid "" 351"<funcprototype> <funcdef>text <function>DropGeometryColumn</function></" 352"funcdef> <paramdef><type>varchar </type> <parameter>table_name</parameter></" 353"paramdef> <paramdef><type>varchar </type> <parameter>column_name</" 354"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>text " 355"<function>DropGeometryColumn</function></funcdef> <paramdef><type>varchar </" 356"type> <parameter>schema_name</parameter></paramdef> <paramdef><type>varchar " 357"</type> <parameter>table_name</parameter></paramdef> <paramdef><type>varchar " 358"</type> <parameter>column_name</parameter></paramdef> </funcprototype> " 359"<funcprototype> <funcdef>text <function>DropGeometryColumn</function></" 360"funcdef> <paramdef><type>varchar </type> <parameter>catalog_name</" 361"parameter></paramdef> <paramdef><type>varchar </type> " 362"<parameter>schema_name</parameter></paramdef> <paramdef><type>varchar </" 363"type> <parameter>table_name</parameter></paramdef> <paramdef><type>varchar </" 364"type> <parameter>column_name</parameter></paramdef> </funcprototype>" 365msgstr "" 366"<funcprototype> <funcdef>text <function>DropGeometryColumn</function></" 367"funcdef> <paramdef><type>varchar </type> <parameter>table_name</parameter></" 368"paramdef> <paramdef><type>varchar </type> <parameter>column_name</" 369"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>text " 370"<function>DropGeometryColumn</function></funcdef> <paramdef><type>varchar </" 371"type> <parameter>schema_name</parameter></paramdef> <paramdef><type>varchar " 372"</type> <parameter>table_name</parameter></paramdef> <paramdef><type>varchar " 373"</type> <parameter>column_name</parameter></paramdef> </funcprototype> " 374"<funcprototype> <funcdef>text <function>DropGeometryColumn</function></" 375"funcdef> <paramdef><type>varchar </type> <parameter>catalog_name</" 376"parameter></paramdef> <paramdef><type>varchar </type> " 377"<parameter>schema_name</parameter></paramdef> <paramdef><type>varchar </" 378"type> <parameter>table_name</parameter></paramdef> <paramdef><type>varchar </" 379"type> <parameter>column_name</parameter></paramdef> </funcprototype>" 380 381#. Tag: para 382#: reference_management.xml:190 383#, no-c-format 384msgid "" 385"Removes a geometry column from a spatial table. Note that schema_name will " 386"need to match the f_table_schema field of the table's row in the " 387"geometry_columns table." 388msgstr "" 389"Supprime une colonne géométrique d'une table spatiale. Note: schema_name " 390"doit correspondre au champ f_table_schema de la table geometry_columns." 391 392#. Tag: para 393#: reference_management.xml:198 394#, no-c-format 395msgid "" 396"Changed: 2.0.0 This function is provided for backward compatibility. Now " 397"that since geometry_columns is now a view against the system catalogs, you " 398"can drop a geometry column like any other table column using <code>ALTER " 399"TABLE</code>" 400msgstr "" 401"Changement: 2.0.0 Function assurant la rétro compatibilité. Maintenant que " 402"geometry_columns est une vue basée sur les catalogues du système, la colonne " 403"géométrique peut etre supprimée d'une table comme tout autre colonne en " 404"utilisant <code>ALTER TABLE</code>" 405 406#. Tag: programlisting 407#: reference_management.xml:205 408#, no-c-format 409msgid "" 410"SELECT DropGeometryColumn ('my_schema','my_spatial_table','geom');\n" 411" ----RESULT output ---\n" 412" dropgeometrycolumn\n" 413"------------------------------------------------------\n" 414" my_schema.my_spatial_table.geom effectively removed.\n" 415"\n" 416"-- In PostGIS 2.0+ the above is also equivalent to the standard\n" 417"-- the standard alter table. Both will deregister from geometry_columns\n" 418"ALTER TABLE my_schema.my_spatial_table DROP column geom;" 419msgstr "" 420 421#. Tag: para 422#: reference_management.xml:210 423#, no-c-format 424msgid "" 425", <xref linkend=\"DropGeometryTable\"/>, <xref linkend=\"geometry_columns\"/>" 426msgstr "" 427", <xref linkend=\"DropGeometryTable\"/>, <xref linkend=\"geometry_columns\"/>" 428 429#. Tag: refname 430#: reference_management.xml:216 431#, no-c-format 432msgid "DropGeometryTable" 433msgstr "DropGeometryTable" 434 435#. Tag: refpurpose 436#: reference_management.xml:218 437#, no-c-format 438msgid "Drops a table and all its references in geometry_columns." 439msgstr "Supprime une table et toutes ces références dans geometry_columns." 440 441#. Tag: funcsynopsis 442#: reference_management.xml:223 443#, no-c-format 444msgid "" 445"<funcprototype> <funcdef>boolean <function>DropGeometryTable</function></" 446"funcdef> <paramdef><type>varchar </type> <parameter>table_name</parameter></" 447"paramdef> </funcprototype> <funcprototype> <funcdef>boolean " 448"<function>DropGeometryTable</function></funcdef> <paramdef><type>varchar </" 449"type> <parameter>schema_name</parameter></paramdef> <paramdef><type>varchar " 450"</type> <parameter>table_name</parameter></paramdef> </funcprototype> " 451"<funcprototype> <funcdef>boolean <function>DropGeometryTable</function></" 452"funcdef> <paramdef><type>varchar </type> <parameter>catalog_name</" 453"parameter></paramdef> <paramdef><type>varchar </type> " 454"<parameter>schema_name</parameter></paramdef> <paramdef><type>varchar </" 455"type> <parameter>table_name</parameter></paramdef> </funcprototype>" 456msgstr "" 457"<funcprototype> <funcdef>boolean <function>DropGeometryTable</function></" 458"funcdef> <paramdef><type>varchar </type> <parameter>table_name</parameter></" 459"paramdef> </funcprototype> <funcprototype> <funcdef>boolean " 460"<function>DropGeometryTable</function></funcdef> <paramdef><type>varchar </" 461"type> <parameter>schema_name</parameter></paramdef> <paramdef><type>varchar " 462"</type> <parameter>table_name</parameter></paramdef> </funcprototype> " 463"<funcprototype> <funcdef>boolean <function>DropGeometryTable</function></" 464"funcdef> <paramdef><type>varchar </type> <parameter>catalog_name</" 465"parameter></paramdef> <paramdef><type>varchar </type> " 466"<parameter>schema_name</parameter></paramdef> <paramdef><type>varchar </" 467"type> <parameter>table_name</parameter></paramdef> </funcprototype>" 468 469#. Tag: para 470#: reference_management.xml:256 471#, no-c-format 472msgid "" 473"Drops a table and all its references in geometry_columns. Note: uses " 474"current_schema() on schema-aware pgsql installations if schema is not " 475"provided." 476msgstr "" 477"Supprime une table et toutes ces références dans geometry_columns. Note: " 478"utilise la fonction current_schema() sur les installations PostgreSQL le " 479"supportant, si le schéma n'est pas fourni." 480 481#. Tag: para 482#: reference_management.xml:261 483#, no-c-format 484msgid "" 485"Changed: 2.0.0 This function is provided for backward compatibility. Now " 486"that since geometry_columns is now a view against the system catalogs, you " 487"can drop a table with geometry columns like any other table using <code>DROP " 488"TABLE</code>" 489msgstr "" 490"Changement: 2.0.0 Function assurant la rétro compatibilité. Maintenant que " 491"geometry_columns est une vue basée sur les catalogues du système, une table " 492"spatiale peut etre supprimée comme tout autre table en utilisant <code>ALTER " 493"TABLE</code>" 494 495#. Tag: programlisting 496#: reference_management.xml:269 497#, no-c-format 498msgid "" 499"SELECT DropGeometryTable ('my_schema','my_spatial_table');\n" 500"----RESULT output ---\n" 501"my_schema.my_spatial_table dropped.\n" 502"\n" 503"-- The above is now equivalent to --\n" 504"DROP TABLE my_schema.my_spatial_table;" 505msgstr "" 506 507#. Tag: para 508#: reference_management.xml:274 509#, no-c-format 510msgid "" 511", <xref linkend=\"DropGeometryColumn\"/>, <xref linkend=\"geometry_columns\"/" 512">" 513msgstr "" 514", <xref linkend=\"DropGeometryColumn\"/>, <xref linkend=\"geometry_columns\"/" 515">" 516 517#. Tag: refname 518#: reference_management.xml:280 519#, no-c-format 520msgid "PostGIS_Extensions_Upgrade" 521msgstr "" 522 523#. Tag: refpurpose 524#: reference_management.xml:282 525#, no-c-format 526msgid "" 527"Upgrades installed postgis packaged extensions (e.g. postgis_sfcgal, " 528"postgis_topology, postgis_sfcgal) to latest installed version. Reports full " 529"postgis version and build configuration infos after." 530msgstr "" 531 532#. Tag: funcprototype 533#: reference_management.xml:289 534#, no-c-format 535msgid "" 536"<funcdef>text <function>PostGIS_Extensions_Upgrade</function></funcdef> " 537"<paramdef></paramdef>" 538msgstr "" 539 540#. Tag: para 541#: reference_management.xml:300 542#, no-c-format 543msgid "" 544"Upgrades installed postgis packaged extensions to latest installed version. " 545"Only extensions you have installed in the database will be upgraded and if " 546"they are already at last installed version, they will not be upgraded. " 547"Reports full postgis version and build configuration infos after. This is " 548"short-hand for doing multiple ALTER EXTENSION .. UPDATE for each postgis " 549"extension. Currently only tries to upgrade extensions postgis, " 550"postgis_sfcgal, postgis_topology, and postgis_tiger_geocoder." 551msgstr "" 552 553#. Tag: para 554#: reference_management.xml:306 555#, no-c-format 556msgid "Availability: 2.5.0" 557msgstr "" 558 559#. Tag: programlisting 560#: reference_management.xml:312 561#, no-c-format 562msgid "SELECT PostGIS_Extensions_Upgrade();" 563msgstr "" 564 565#. Tag: screen 566#: reference_management.xml:313 567#, no-c-format 568msgid "" 569"NOTICE: ALTER EXTENSION postgis_tiger_geocoder UPDATE TO \"2.5.0dev\";\n" 570"CONTEXT: PL/pgSQL function postgis_extensions_upgrade() line 10 at RAISE\n" 571"NOTICE: ALTER EXTENSION postgis_topology UPDATE TO \"2.5.0dev\";\n" 572"CONTEXT: PL/pgSQL function postgis_extensions_upgrade() line 10 at RAISE\n" 573"\n" 574" postgis_extensions_upgrade\n" 575"----------------------------------------------------------------------------------\n" 576"POSTGIS=\"2.5.0dev r15966\" [EXTENSION] PGSQL=\"100\"\n" 577"GEOS=\"3.7.0dev-CAPI-1.11.0 8fe2ce6\" SFCGAL=\"1.3.1\"\n" 578"PROJ=\"Rel. 4.9.3, 15 August 2016\" GDAL=\"GDAL 2.2.2, released " 579"2017/09/15\"\n" 580"LIBXML=\"2.7.8\" LIBJSON=\"0.12\" LIBPROTOBUF=\"1.2.1\" TOPOLOGY RASTER\n" 581"(1 row)" 582msgstr "" 583 584#. Tag: para 585#: reference_management.xml:319 reference_management.xml:367 586#, no-c-format 587msgid "" 588", <xref linkend=\"PostGIS_GEOS_Version\"/>, <xref linkend=" 589"\"PostGIS_Lib_Version\"/>, <xref linkend=\"PostGIS_LibXML_Version\"/>, <xref " 590"linkend=\"PostGIS_PROJ_Version\"/>, <xref linkend=\"PostGIS_Version\"/>" 591msgstr "" 592", <xref linkend=\"PostGIS_GEOS_Version\"/>, <xref linkend=" 593"\"PostGIS_Lib_Version\"/>, <xref linkend=\"PostGIS_LibXML_Version\"/>, <xref " 594"linkend=\"PostGIS_PROJ_Version\"/>, <xref linkend=\"PostGIS_Version\"/>" 595 596#. Tag: refname 597#: reference_management.xml:334 598#, no-c-format 599msgid "PostGIS_Full_Version" 600msgstr "PostGIS_Full_Version" 601 602#. Tag: refpurpose 603#: reference_management.xml:336 604#, no-c-format 605msgid "Reports full postgis version and build configuration infos." 606msgstr "" 607"Affiche la version complète de PostGIS et les informations de compilation." 608 609#. Tag: funcprototype 610#: reference_management.xml:342 611#, no-c-format 612msgid "" 613"<funcdef>text <function>PostGIS_Full_Version</function></funcdef> " 614"<paramdef></paramdef>" 615msgstr "" 616"<funcdef>text <function>PostGIS_Full_Version</function></funcdef> " 617"<paramdef></paramdef>" 618 619#. Tag: para 620#: reference_management.xml:353 621#, no-c-format 622msgid "" 623"Reports full postgis version and build configuration infos. Also informs " 624"about synchronization between libraries and scripts suggesting upgrades as " 625"needed." 626msgstr "" 627"Affiche la version complète de PostGIS et les informations de compilation. " 628"Donne également des informations sur la synchronisation entre les " 629"bibliothèques et les scripts en conseillant les mises à jour si besoin." 630 631#. Tag: programlisting 632#: reference_management.xml:361 633#, no-c-format 634msgid "" 635"SELECT PostGIS_Full_Version();\n" 636" postgis_full_version\n" 637"----------------------------------------------------------------------------------\n" 638"POSTGIS=\"2.2.0dev r12699\" GEOS=\"3.5.0dev-CAPI-1.9.0 r3989\" SFCGAL=" 639"\"1.0.4\" PROJ=\"Rel. 4.8.0, 6 March 2012\"\n" 640"GDAL=\"GDAL 1.11.0, released 2014/04/16\" LIBXML=\"2.7.8\" LIBJSON=\"0.12\" " 641"RASTER\n" 642"(1 row)" 643msgstr "" 644 645#. Tag: refname 646#: reference_management.xml:380 647#, no-c-format 648msgid "PostGIS_GEOS_Version" 649msgstr "PostGIS_GEOS_Version" 650 651#. Tag: refpurpose 652#: reference_management.xml:382 653#, no-c-format 654msgid "Returns the version number of the GEOS library." 655msgstr "Retourne le numéro de version de la bibliothèque GEOS" 656 657#. Tag: funcprototype 658#: reference_management.xml:388 659#, no-c-format 660msgid "" 661"<funcdef>text <function>PostGIS_GEOS_Version</function></funcdef> " 662"<paramdef></paramdef>" 663msgstr "" 664"<funcdef>text <function>PostGIS_GEOS_Version</function></funcdef> " 665"<paramdef></paramdef>" 666 667#. Tag: para 668#: reference_management.xml:399 669#, no-c-format 670msgid "" 671"Returns the version number of the GEOS library, or <varname>NULL</varname> " 672"if GEOS support is not enabled." 673msgstr "" 674"Retourne le numéro de version de la bibliothèque GEOS ou <varname>NULL</" 675"varname> si le support GEOS n'est pas activé" 676 677#. Tag: programlisting 678#: reference_management.xml:406 679#, no-c-format 680msgid "" 681"SELECT PostGIS_GEOS_Version();\n" 682" postgis_geos_version\n" 683"----------------------\n" 684" 3.1.0-CAPI-1.5.0\n" 685"(1 row)" 686msgstr "" 687"SELECT PostGIS_GEOS_Version();\n" 688" postgis_geos_version\n" 689"----------------------\n" 690" 3.1.0-CAPI-1.5.0\n" 691"(1 row)" 692 693#. Tag: para 694#: reference_management.xml:412 reference_management.xml:453 695#, no-c-format 696msgid "" 697", <xref linkend=\"PostGIS_Lib_Version\"/>, <xref linkend=" 698"\"PostGIS_LibXML_Version\"/>, <xref linkend=\"PostGIS_PROJ_Version\"/>, " 699"<xref linkend=\"PostGIS_Version\"/>" 700msgstr "" 701", <xref linkend=\"PostGIS_Lib_Version\"/>, <xref linkend=" 702"\"PostGIS_LibXML_Version\"/>, <xref linkend=\"PostGIS_PROJ_Version\"/>, " 703"<xref linkend=\"PostGIS_Version\"/>" 704 705#. Tag: refname 706#: reference_management.xml:422 707#, no-c-format 708msgid "PostGIS_Liblwgeom_Version" 709msgstr "" 710 711#. Tag: refpurpose 712#: reference_management.xml:424 713#, no-c-format 714msgid "" 715"Returns the version number of the liblwgeom library. This should match the " 716"version of PostGIS." 717msgstr "" 718 719#. Tag: funcprototype 720#: reference_management.xml:430 721#, no-c-format 722msgid "" 723"<funcdef>text <function>PostGIS_Liblwgeom_Version</function></funcdef> " 724"<paramdef></paramdef>" 725msgstr "" 726 727#. Tag: para 728#: reference_management.xml:441 729#, no-c-format 730msgid "Returns the version number of the liblwgeom library/" 731msgstr "" 732 733#. Tag: programlisting 734#: reference_management.xml:447 735#, no-c-format 736msgid "" 737"SELECT PostGIS_Liblwgeom_Version();\n" 738"postgis_liblwgeom_version\n" 739"--------------------------\n" 740"2.3.3 r15473\n" 741"(1 row)" 742msgstr "" 743 744#. Tag: refname 745#: reference_management.xml:463 746#, no-c-format 747msgid "PostGIS_LibXML_Version" 748msgstr "PostGIS_LibXML_Version" 749 750#. Tag: refpurpose 751#: reference_management.xml:465 752#, no-c-format 753msgid "Returns the version number of the libxml2 library." 754msgstr "Retourne le numéro de version de la bibliothèque libxml2." 755 756#. Tag: funcprototype 757#: reference_management.xml:471 758#, no-c-format 759msgid "" 760"<funcdef>text <function>PostGIS_LibXML_Version</function></funcdef> " 761"<paramdef></paramdef>" 762msgstr "" 763"<funcdef>text <function>PostGIS_LibXML_Version</function></funcdef> " 764"<paramdef></paramdef>" 765 766#. Tag: para 767#: reference_management.xml:482 768#, no-c-format 769msgid "Returns the version number of the LibXML2 library." 770msgstr "Retourne le numéro de version de la bibliothèque libxml2." 771 772#. Tag: para 773#: reference_management.xml:483 774#, no-c-format 775msgid "Availability: 1.5" 776msgstr "Disponibilité: 1.5" 777 778#. Tag: programlisting 779#: reference_management.xml:489 780#, no-c-format 781msgid "" 782"SELECT PostGIS_LibXML_Version();\n" 783" postgis_libxml_version\n" 784"----------------------\n" 785" 2.7.6\n" 786"(1 row)" 787msgstr "" 788"SELECT PostGIS_LibXML_Version();\n" 789" postgis_libxml_version\n" 790"----------------------\n" 791" 2.7.6\n" 792"(1 row)" 793 794#. Tag: para 795#: reference_management.xml:495 796#, no-c-format 797msgid "" 798", <xref linkend=\"PostGIS_Lib_Version\"/>, <xref linkend=" 799"\"PostGIS_PROJ_Version\"/>, <xref linkend=\"PostGIS_GEOS_Version\"/>, <xref " 800"linkend=\"PostGIS_Version\"/>" 801msgstr "" 802", <xref linkend=\"PostGIS_Lib_Version\"/>, <xref linkend=" 803"\"PostGIS_PROJ_Version\"/>, <xref linkend=\"PostGIS_GEOS_Version\"/>, <xref " 804"linkend=\"PostGIS_Version\"/>" 805 806#. Tag: refname 807#: reference_management.xml:505 808#, no-c-format 809msgid "PostGIS_Lib_Build_Date" 810msgstr "PostGIS_Lib_Build_Date" 811 812#. Tag: refpurpose 813#: reference_management.xml:507 814#, no-c-format 815msgid "<refpurpose>Returns build date of the PostGIS library.</refpurpose>" 816msgstr "" 817"<refpurpose>Retourne la date de compilation de la bibliotèque PostGIS.</" 818"refpurpose>" 819 820#. Tag: funcprototype 821#: reference_management.xml:512 822#, no-c-format 823msgid "" 824"<funcdef>text <function>PostGIS_Lib_Build_Date</function></funcdef> " 825"<paramdef></paramdef>" 826msgstr "" 827"<funcdef>text <function>PostGIS_Lib_Build_Date</function></funcdef> " 828"<paramdef></paramdef>" 829 830#. Tag: para 831#: reference_management.xml:523 832#, no-c-format 833msgid "<para>Returns build date of the PostGIS library.</para>" 834msgstr "" 835"<para>Retourne la date de compilation de la bibliothèque PostGIS.</para>" 836 837#. Tag: programlisting 838#: reference_management.xml:529 839#, no-c-format 840msgid "" 841"SELECT PostGIS_Lib_Build_Date();\n" 842" postgis_lib_build_date\n" 843"------------------------\n" 844" 2008-06-21 17:53:21\n" 845"(1 row)" 846msgstr "" 847"SELECT PostGIS_Lib_Build_Date();\n" 848" postgis_lib_build_date\n" 849"------------------------\n" 850" 2008-06-21 17:53:21\n" 851"(1 row)" 852 853#. Tag: refname 854#: reference_management.xml:535 855#, no-c-format 856msgid "PostGIS_Lib_Version" 857msgstr "PostGIS_Lib_Version" 858 859#. Tag: refpurpose 860#: reference_management.xml:537 861#, no-c-format 862msgid "" 863"<refpurpose>Returns the version number of the PostGIS library.</refpurpose>" 864msgstr "" 865"<refpurpose>Retourne le numéro de version de la bibliothèque PostGIS.</" 866"refpurpose>" 867 868#. Tag: funcprototype 869#: reference_management.xml:543 870#, no-c-format 871msgid "" 872"<funcdef>text <function>PostGIS_Lib_Version</function></funcdef> <paramdef></" 873"paramdef>" 874msgstr "" 875"<funcdef>text <function>PostGIS_Lib_Version</function></funcdef> <paramdef></" 876"paramdef>" 877 878#. Tag: para 879#: reference_management.xml:554 880#, no-c-format 881msgid "<para>Returns the version number of the PostGIS library.</para>" 882msgstr "<para>Retourne le numéro de version de la bibliothèque PostGIS.</para>" 883 884#. Tag: programlisting 885#: reference_management.xml:560 886#, no-c-format 887msgid "" 888"SELECT PostGIS_Lib_Version();\n" 889" postgis_lib_version\n" 890"---------------------\n" 891" 1.3.3\n" 892"(1 row)" 893msgstr "" 894"SELECT PostGIS_Lib_Version();\n" 895" postgis_lib_version\n" 896"---------------------\n" 897" 1.3.3\n" 898"(1 row)" 899 900#. Tag: para 901#: reference_management.xml:566 902#, no-c-format 903msgid "" 904", <xref linkend=\"PostGIS_GEOS_Version\"/>, <xref linkend=" 905"\"PostGIS_LibXML_Version\"/>, <xref linkend=\"PostGIS_PROJ_Version\"/>, " 906"<xref linkend=\"PostGIS_Version\"/>" 907msgstr "" 908", <xref linkend=\"PostGIS_GEOS_Version\"/>, <xref linkend=" 909"\"PostGIS_LibXML_Version\"/>, <xref linkend=\"PostGIS_PROJ_Version\"/>, " 910"<xref linkend=\"PostGIS_Version\"/>" 911 912#. Tag: refname 913#: reference_management.xml:576 914#, no-c-format 915msgid "PostGIS_PROJ_Version" 916msgstr "PostGIS_PROJ_Version" 917 918#. Tag: refpurpose 919#: reference_management.xml:578 920#, no-c-format 921msgid "Returns the version number of the PROJ4 library." 922msgstr "Retourne le numéro de version de la bibliothèque PROJ4." 923 924#. Tag: funcprototype 925#: reference_management.xml:584 926#, no-c-format 927msgid "" 928"<funcdef>text <function>PostGIS_PROJ_Version</function></funcdef> " 929"<paramdef></paramdef>" 930msgstr "" 931"<funcdef>text <function>PostGIS_PROJ_Version</function></funcdef> " 932"<paramdef></paramdef>" 933 934#. Tag: para 935#: reference_management.xml:595 936#, no-c-format 937msgid "" 938"Returns the version number of the PROJ4 library, or <varname>NULL</varname> " 939"if PROJ4 support is not enabled." 940msgstr "" 941"Retourne le numéro de version de la bibliothèque PROJ4, ou <varname>NULL</" 942"varname> si PROJ4 n'est pas installée." 943 944#. Tag: programlisting 945#: reference_management.xml:602 946#, no-c-format 947msgid "" 948"SELECT PostGIS_PROJ_Version();\n" 949" postgis_proj_version\n" 950"-------------------------\n" 951" Rel. 4.4.9, 29 Oct 2004\n" 952"(1 row)" 953msgstr "" 954"SELECT PostGIS_PROJ_Version();\n" 955" postgis_proj_version\n" 956"-------------------------\n" 957" Rel. 4.4.9, 29 Oct 2004\n" 958"(1 row)" 959 960#. Tag: para 961#: reference_management.xml:608 reference_management.xml:650 962#, no-c-format 963msgid "" 964", <xref linkend=\"PostGIS_GEOS_Version\"/>, <xref linkend=" 965"\"PostGIS_Lib_Version\"/>, <xref linkend=\"PostGIS_LibXML_Version\"/>, <xref " 966"linkend=\"PostGIS_Version\"/>" 967msgstr "" 968", <xref linkend=\"PostGIS_GEOS_Version\"/>, <xref linkend=" 969"\"PostGIS_Lib_Version\"/>, <xref linkend=\"PostGIS_LibXML_Version\"/>, <xref " 970"linkend=\"PostGIS_Version\"/>" 971 972#. Tag: refname 973#: reference_management.xml:618 974#, no-c-format 975msgid "PostGIS_Scripts_Build_Date" 976msgstr "PostGIS_Scripts_Build_Date" 977 978#. Tag: refpurpose 979#: reference_management.xml:620 980#, no-c-format 981msgid "<refpurpose>Returns build date of the PostGIS scripts.</refpurpose>" 982msgstr "" 983"<refpurpose>Retourne la date de génération des scripts PostGIS.</refpurpose>" 984 985#. Tag: funcprototype 986#: reference_management.xml:625 987#, no-c-format 988msgid "" 989"<funcdef>text <function>PostGIS_Scripts_Build_Date</function></funcdef> " 990"<paramdef></paramdef>" 991msgstr "" 992"<funcdef>text <function>PostGIS_Scripts_Build_Date</function></funcdef> " 993"<paramdef></paramdef>" 994 995#. Tag: para 996#: reference_management.xml:636 997#, no-c-format 998msgid "<para>Returns build date of the PostGIS scripts.</para>" 999msgstr "<para>Retourne la date de génération des scripts PostGIS.</para>" 1000 1001#. Tag: para 1002#: reference_management.xml:638 1003#, no-c-format 1004msgid "Availability: 1.0.0RC1" 1005msgstr "Disponibilité: 1.0.0RC1" 1006 1007#. Tag: programlisting 1008#: reference_management.xml:644 1009#, no-c-format 1010msgid "" 1011"SELECT PostGIS_Scripts_Build_Date();\n" 1012" postgis_scripts_build_date\n" 1013"-------------------------\n" 1014" 2007-08-18 09:09:26\n" 1015"(1 row)" 1016msgstr "" 1017"SELECT PostGIS_Scripts_Build_Date();\n" 1018" postgis_scripts_build_date\n" 1019"-------------------------\n" 1020" 2007-08-18 09:09:26\n" 1021"(1 row)" 1022 1023#. Tag: refname 1024#: reference_management.xml:660 1025#, no-c-format 1026msgid "PostGIS_Scripts_Installed" 1027msgstr "PostGIS_Scripts_Installed" 1028 1029#. Tag: refpurpose 1030#: reference_management.xml:662 1031#, no-c-format 1032msgid "" 1033"<refpurpose>Returns version of the postgis scripts installed in this " 1034"database.</refpurpose>" 1035msgstr "" 1036"<refpurpose>Retourne le numéro de version des scripts PostGIS installés dans " 1037"cette base de données.</refpurpose>" 1038 1039#. Tag: funcprototype 1040#: reference_management.xml:668 1041#, no-c-format 1042msgid "" 1043"<funcdef>text <function>PostGIS_Scripts_Installed</function></funcdef> " 1044"<paramdef></paramdef>" 1045msgstr "" 1046"<funcdef>text <function>PostGIS_Scripts_Installed</function></funcdef> " 1047"<paramdef></paramdef>" 1048 1049#. Tag: para 1050#: reference_management.xml:679 1051#, no-c-format 1052msgid "" 1053"<para>Returns version of the postgis scripts installed in this database.</" 1054"para>" 1055msgstr "" 1056"<para>Retourne le numéro de version des scripts PostGIS installés dans cette " 1057"base de données</para>" 1058 1059#. Tag: para 1060#: reference_management.xml:683 1061#, no-c-format 1062msgid "" 1063"If the output of this function doesn't match the output of <xref linkend=" 1064"\"PostGIS_Scripts_Released\"/> you probably missed to properly upgrade an " 1065"existing database. See the <link linkend=\"upgrading\">Upgrading</link> " 1066"section for more info." 1067msgstr "" 1068"Si la sortie de cette fonction ne correspond pas à la sortie de <xref " 1069"linkend=\"PostGIS_Scripts_Released\"/> cela veut probablement dire que la " 1070"mise à jour de la base de données n'a pas fonctionné. Cf. section <link " 1071"linkend=\"upgrading\">Upgrading</link> pour plus d'information" 1072 1073#. Tag: para 1074#: reference_management.xml:690 reference_management.xml:736 1075#, no-c-format 1076msgid "Availability: 0.9.0" 1077msgstr "Disponibilité: 0.9.0" 1078 1079#. Tag: programlisting 1080#: reference_management.xml:696 1081#, no-c-format 1082msgid "" 1083"SELECT PostGIS_Scripts_Installed();\n" 1084" postgis_scripts_installed\n" 1085"-------------------------\n" 1086" 1.5.0SVN\n" 1087"(1 row)" 1088msgstr "" 1089"SELECT PostGIS_Scripts_Installed();\n" 1090" postgis_scripts_installed\n" 1091"-------------------------\n" 1092" 1.5.0SVN\n" 1093"(1 row)" 1094 1095#. Tag: para 1096#: reference_management.xml:702 1097#, no-c-format 1098msgid "" 1099", <xref linkend=\"PostGIS_Scripts_Released\"/>, <xref linkend=" 1100"\"PostGIS_Version\"/>" 1101msgstr "" 1102", <xref linkend=\"PostGIS_Scripts_Released\"/>, <xref linkend=" 1103"\"PostGIS_Version\"/>" 1104 1105#. Tag: refname 1106#: reference_management.xml:708 1107#, no-c-format 1108msgid "PostGIS_Scripts_Released" 1109msgstr "PostGIS_Scripts_Released" 1110 1111#. Tag: refpurpose 1112#: reference_management.xml:710 1113#, no-c-format 1114msgid "" 1115"<refpurpose>Returns the version number of the postgis.sql script released " 1116"with the installed postgis lib.</refpurpose>" 1117msgstr "" 1118"<refpurpose>Retourne le numéro de version des scripts PostGIS livrés avec la " 1119"bibliothèque PostGIS installée</refpurpose>" 1120 1121#. Tag: funcprototype 1122#: reference_management.xml:716 1123#, no-c-format 1124msgid "" 1125"<funcdef>text <function>PostGIS_Scripts_Released</function></funcdef> " 1126"<paramdef></paramdef>" 1127msgstr "" 1128"<funcdef>text <function>PostGIS_Scripts_Released</function></funcdef> " 1129"<paramdef></paramdef>" 1130 1131#. Tag: para 1132#: reference_management.xml:727 1133#, no-c-format 1134msgid "" 1135"<para>Returns the version number of the postgis.sql script released with the " 1136"installed postgis lib.</para>" 1137msgstr "" 1138"<para>Retourne le numéro de version des scripts PostGIS livrés avec la " 1139"bibliothèque PostGIS installée.</para>" 1140 1141#. Tag: para 1142#: reference_management.xml:731 1143#, no-c-format 1144msgid "" 1145"Starting with version 1.1.0 this function returns the same value of <xref " 1146"linkend=\"PostGIS_Lib_Version\"/>. Kept for backward compatibility." 1147msgstr "" 1148"A partir de la version 1.1.0, cette fonction retourne la même valeur que " 1149"<xref linkend=\"PostGIS_Lib_Version\"/>. Conservée pour rétro compatibilité." 1150 1151#. Tag: programlisting 1152#: reference_management.xml:742 1153#, no-c-format 1154msgid "" 1155"SELECT PostGIS_Scripts_Released();\n" 1156" postgis_scripts_released\n" 1157"-------------------------\n" 1158" 1.3.4SVN\n" 1159"(1 row)" 1160msgstr "" 1161"SELECT PostGIS_Scripts_Released();\n" 1162" postgis_scripts_released\n" 1163"-------------------------\n" 1164" 1.3.4SVN\n" 1165"(1 row)" 1166 1167#. Tag: para 1168#: reference_management.xml:748 1169#, no-c-format 1170msgid "" 1171", <xref linkend=\"PostGIS_Scripts_Installed\"/>, <xref linkend=" 1172"\"PostGIS_Lib_Version\"/>" 1173msgstr "" 1174", <xref linkend=\"PostGIS_Scripts_Installed\"/>, <xref linkend=" 1175"\"PostGIS_Lib_Version\"/>" 1176 1177#. Tag: refname 1178#: reference_management.xml:754 1179#, no-c-format 1180msgid "PostGIS_Version" 1181msgstr "PostGIS_Version" 1182 1183#. Tag: refpurpose 1184#: reference_management.xml:756 1185#, no-c-format 1186msgid "" 1187"<refpurpose>Returns PostGIS version number and compile-time options.</" 1188"refpurpose>" 1189msgstr "" 1190"<refpurpose>Retourne le numéro de version PostGIS et des options de " 1191"compilation.</refpurpose>" 1192 1193#. Tag: funcprototype 1194#: reference_management.xml:762 1195#, no-c-format 1196msgid "" 1197"<funcdef>text <function>PostGIS_Version</function></funcdef> <paramdef></" 1198"paramdef>" 1199msgstr "" 1200"<funcdef>text <function>PostGIS_Version</function></funcdef> <paramdef></" 1201"paramdef>" 1202 1203#. Tag: para 1204#: reference_management.xml:773 1205#, no-c-format 1206msgid "<para>Returns PostGIS version number and compile-time options.</para>" 1207msgstr "" 1208"<para>Retourne le numéro de version PostGIS et des options de compilation.</" 1209"para>" 1210 1211#. Tag: programlisting 1212#: reference_management.xml:779 1213#, no-c-format 1214msgid "" 1215"SELECT PostGIS_Version();\n" 1216" postgis_version\n" 1217"---------------------------------------\n" 1218" 1.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1\n" 1219"(1 row)" 1220msgstr "" 1221"SELECT PostGIS_Version();\n" 1222" postgis_version\n" 1223"---------------------------------------\n" 1224" 1.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1\n" 1225"(1 row)" 1226 1227#. Tag: para 1228#: reference_management.xml:785 1229#, no-c-format 1230msgid "" 1231", <xref linkend=\"PostGIS_GEOS_Version\"/>, <xref linkend=" 1232"\"PostGIS_Lib_Version\"/>, <xref linkend=\"PostGIS_LibXML_Version\"/>, <xref " 1233"linkend=\"PostGIS_PROJ_Version\"/>" 1234msgstr "" 1235", <xref linkend=\"PostGIS_GEOS_Version\"/>, <xref linkend=" 1236"\"PostGIS_Lib_Version\"/>, <xref linkend=\"PostGIS_LibXML_Version\"/>, <xref " 1237"linkend=\"PostGIS_PROJ_Version\"/>" 1238 1239#. Tag: refname 1240#: reference_management.xml:795 1241#, no-c-format 1242msgid "Populate_Geometry_Columns" 1243msgstr "Populate_Geometry_Columns" 1244 1245#. Tag: refpurpose 1246#: reference_management.xml:797 1247#, no-c-format 1248msgid "" 1249"Ensures geometry columns are defined with type modifiers or have appropriate " 1250"spatial constraints This ensures they will be registered correctly in " 1251"<varname>geometry_columns</varname> view. By default will convert all " 1252"geometry columns with no type modifier to ones with type modifiers. To get " 1253"old behavior set <varname>use_typmod=false</varname>" 1254msgstr "" 1255"S'assure que les colonnes géométriques sont définies avec un modificateur de " 1256"type ou dispose des contraintes nécessaires. Garantit un enregistrement " 1257"correct dans la vue <varname>geometry_columns</varname>. Par défaut, " 1258"convertit toutes les colonnes géométriques sans modificateur de type en " 1259"colonnes avec modificateurs. Pour conserver l'ancien mécanisme, mettre " 1260"<varname>use_typmod=false</varname>" 1261 1262#. Tag: funcsynopsis 1263#: reference_management.xml:803 1264#, no-c-format 1265msgid "" 1266"<funcprototype> <funcdef>text <function>Populate_Geometry_Columns</" 1267"function></funcdef> <paramdef><type>boolean </type> " 1268"<parameter>use_typmod=true</parameter></paramdef> </funcprototype> " 1269"<funcprototype> <funcdef>int <function>Populate_Geometry_Columns</function></" 1270"funcdef> <paramdef><type>oid</type> <parameter>relation_oid</parameter></" 1271"paramdef> <paramdef><type>boolean </type> <parameter>use_typmod=true</" 1272"parameter></paramdef> </funcprototype>" 1273msgstr "" 1274"<funcprototype> <funcdef>text <function>Populate_Geometry_Columns</" 1275"function></funcdef> <paramdef><type>boolean </type> " 1276"<parameter>use_typmod=true</parameter></paramdef> </funcprototype> " 1277"<funcprototype> <funcdef>int <function>Populate_Geometry_Columns</function></" 1278"funcdef> <paramdef><type>oid</type> <parameter>relation_oid</parameter></" 1279"paramdef> <paramdef><type>boolean </type> <parameter>use_typmod=true</" 1280"parameter></paramdef> </funcprototype>" 1281 1282#. Tag: para 1283#: reference_management.xml:822 1284#, no-c-format 1285msgid "" 1286"Ensures geometry columns have appropriate type modifiers or spatial " 1287"constraints to ensure they are registered correctly in " 1288"<varname>geometry_columns</varname> table." 1289msgstr "" 1290"S'assure que les colonnes géométriques sont définies avec un modificateur de " 1291"type ou dispose des contraintes nécessaires pour Garantir un enregistrement " 1292"correct dans la vue <varname>geometry_columns</varname>." 1293 1294#. Tag: para 1295#: reference_management.xml:824 1296#, no-c-format 1297msgid "" 1298"For backwards compatibility and for spatial needs such as table inheritance " 1299"where each child table may have different geometry type, the old check " 1300"constraint behavior is still supported. If you need the old behavior, you " 1301"need to pass in the new optional argument as false " 1302"<varname>use_typmod=false</varname>. When this is done geometry columns will " 1303"be created with no type modifiers but will have 3 constraints defined. In " 1304"particular, this means that every geometry column belonging to a table has " 1305"at least three constraints:" 1306msgstr "" 1307"Pour conserver la rétro compatibilité et pour des besoins particuliers comme " 1308"par exemple des tables héritées ayant des types géométriques différents, " 1309"l'ancien mécanisme est toujours supporté. Si ce mécanisme est nécessaire, le " 1310"nouveau paramètre optionnel doit être mis à false: " 1311"<varname>use_typmod=false</varname>. Avec cette valeur, la colonne " 1312"géométrique sera créée sans modificateur de type mais 3 contraintes seront " 1313"définies. Cela signifie concrètement que chaque colonne géométrique de la " 1314"table aura au moins 3 contraintes:" 1315 1316#. Tag: para 1317#: reference_management.xml:832 1318#, no-c-format 1319msgid "" 1320"<varname>enforce_dims_the_geom</varname> - ensures every geometry has the " 1321"same dimension (see <xref linkend=\"ST_NDims\"/>)" 1322msgstr "" 1323"<varname>enforce_dims_the_geom</varname> - ensures every geometry has the " 1324"same dimension (see <xref linkend=\"ST_NDims\"/>)" 1325 1326#. Tag: para 1327#: reference_management.xml:838 1328#, no-c-format 1329msgid "" 1330"<varname>enforce_geotype_the_geom</varname> - ensures every geometry is of " 1331"the same type (see <xref linkend=\"GeometryType\"/>)" 1332msgstr "" 1333"<varname>enforce_geotype_the_geom</varname> - ensures every geometry is of " 1334"the same type (see <xref linkend=\"GeometryType\"/>)" 1335 1336#. Tag: para 1337#: reference_management.xml:844 1338#, no-c-format 1339msgid "" 1340"<varname>enforce_srid_the_geom</varname> - ensures every geometry is in the " 1341"same projection (see <xref linkend=\"ST_SRID\"/>)" 1342msgstr "" 1343"<varname>enforce_srid_the_geom</varname> - s'assure que toutes les " 1344"géométries sont dans la même projection (see <xref linkend=\"ST_SRID\"/>)" 1345 1346#. Tag: para 1347#: reference_management.xml:850 1348#, no-c-format 1349msgid "" 1350"If a table <varname>oid</varname> is provided, this function tries to " 1351"determine the srid, dimension, and geometry type of all geometry columns in " 1352"the table, adding constraints as necessary. If successful, an appropriate " 1353"row is inserted into the geometry_columns table, otherwise, the exception is " 1354"caught and an error notice is raised describing the problem." 1355msgstr "" 1356"Si un identifiant de table <varname>oid</varname> est fourni, cette fonction " 1357"tente de déterminer le SRID, la dimension et le type géométrique de toutes " 1358"les colonnes géométriques de la table, ajoutant des contraintes si " 1359"nécessaire. En cas de succès, une ligne est insérée dans la table " 1360"geometry_columns, sinon, une erreur est affichée indiquant le problème." 1361 1362#. Tag: para 1363#: reference_management.xml:857 1364#, no-c-format 1365msgid "" 1366"If the <varname>oid</varname> of a view is provided, as with a table oid, " 1367"this function tries to determine the srid, dimension, and type of all the " 1368"geometries in the view, inserting appropriate entries into the " 1369"<varname>geometry_columns</varname> table, but nothing is done to enforce " 1370"constraints." 1371msgstr "" 1372"Si un identifiant de vue <varname>oid</varname> est fourni, comme pour un " 1373"oid de table, cette fonction tente de déterminer le SRID, la dimension et le " 1374"type géométrique de toutes les colonnes géométriques de la vue, insérant les " 1375"informations correspondantes dans la table geometry_columns. Rien n'est fait " 1376"concernant les contraintes." 1377 1378#. Tag: para 1379#: reference_management.xml:863 1380#, no-c-format 1381msgid "" 1382"The parameterless variant is a simple wrapper for the parameterized variant " 1383"that first truncates and repopulates the geometry_columns table for every " 1384"spatial table and view in the database, adding spatial constraints to tables " 1385"where appropriate. It returns a summary of the number of geometry columns " 1386"detected in the database and the number that were inserted into the " 1387"<varname>geometry_columns</varname> table. The parameterized version simply " 1388"returns the number of rows inserted into the <varname>geometry_columns</" 1389"varname> table." 1390msgstr "" 1391"La version sans paramètre est un raccourci pour la version avec paramètres. " 1392"Elle vide puis remplit la table geometry_columns pour chaque table ou vue " 1393"spatiale de la base, ajoutant les contraintes aux tables si besoin. Retourne " 1394"un résumé montrant le nombre de colonnes géométriques identifiées dans la " 1395"base et le nombre inséré dans la table <varname>geometry_columns</varname>. " 1396"La version avec paramètres renvoie juste le nombre de lignes insérées dans " 1397"la table <varname>geometry_columns</varname> " 1398 1399#. Tag: para 1400#: reference_management.xml:871 1401#, no-c-format 1402msgid "Availability: 1.4.0" 1403msgstr "Disponibilité: 1.4.0" 1404 1405#. Tag: para 1406#: reference_management.xml:872 1407#, no-c-format 1408msgid "" 1409"Changed: 2.0.0 By default, now uses type modifiers instead of check " 1410"constraints to constrain geometry types. You can still use check constraint " 1411"behavior instead by using the new <varname>use_typmod</varname> and setting " 1412"it to false." 1413msgstr "" 1414"Changement: 2.0.0 Par défaut, utilise les modificateurs de type au lieu de " 1415"contraintes de vérification pour contraindre les types géométriques. Le " 1416"comportement basé sur les contraintes peut être activé en mettant le nouveau " 1417"paramètre <varname>use_typmod</varname> à false." 1418 1419#. Tag: para 1420#: reference_management.xml:874 1421#, no-c-format 1422msgid "" 1423"Enhanced: 2.0.0 <varname>use_typmod</varname> optional argument was " 1424"introduced that allows controlling if columns are created with typmodifiers " 1425"or with check constraints." 1426msgstr "" 1427"Amélioration: 2.0.0 L'argument optionnel <varname>use_typmod</varname> a été " 1428"introduit pour controler si les colonnes sont créés avec des modificateurs " 1429"de type ou des contraintes de vérification." 1430 1431#. Tag: programlisting 1432#: reference_management.xml:880 1433#, no-c-format 1434msgid "" 1435"CREATE TABLE public.myspatial_table(gid serial, geom geometry);\n" 1436"INSERT INTO myspatial_table(geom) VALUES(ST_GeomFromText('LINESTRING(1 2, 3 " 1437"4)',4326) );\n" 1438"-- This will now use typ modifiers. For this to work, there must exist " 1439"data\n" 1440"SELECT Populate_Geometry_Columns('public.myspatial_table'::regclass);\n" 1441"\n" 1442"populate_geometry_columns\n" 1443"--------------------------\n" 1444" 1\n" 1445"\n" 1446"\n" 1447"\\d myspatial_table\n" 1448"\n" 1449" Table \"public.myspatial_table\"\n" 1450" Column | Type | Modifiers\n" 1451"--------+---------------------------" 1452"+---------------------------------------------------------------\n" 1453" gid | integer | not null default " 1454"nextval('myspatial_table_gid_seq'::regclass)\n" 1455" geom | geometry(LineString,4326) |" 1456msgstr "" 1457 1458#. Tag: programlisting 1459#: reference_management.xml:882 1460#, no-c-format 1461msgid "" 1462"-- This will change the geometry columns to use constraints if they are not " 1463"typmod or have constraints already.\n" 1464"--For this to work, there must exist data\n" 1465"CREATE TABLE public.myspatial_table_cs(gid serial, geom geometry);\n" 1466"INSERT INTO myspatial_table_cs(geom) VALUES(ST_GeomFromText('LINESTRING(1 2, " 1467"3 4)',4326) );\n" 1468"SELECT Populate_Geometry_Columns('public.myspatial_table_cs'::regclass, " 1469"false);\n" 1470"populate_geometry_columns\n" 1471"--------------------------\n" 1472" 1\n" 1473"\\d myspatial_table_cs\n" 1474"\n" 1475" Table \"public.myspatial_table_cs\"\n" 1476" Column | Type | Modifiers\n" 1477"--------+----------" 1478"+------------------------------------------------------------------\n" 1479" gid | integer | not null default nextval('myspatial_table_cs_gid_seq'::" 1480"regclass)\n" 1481" geom | geometry |\n" 1482"Check constraints:\n" 1483" \"enforce_dims_geom\" CHECK (st_ndims(geom) = 2)\n" 1484" \"enforce_geotype_geom\" CHECK (geometrytype(geom) = 'LINESTRING'::text " 1485"OR geom IS NULL)\n" 1486" \"enforce_srid_geom\" CHECK (st_srid(geom) = 4326)" 1487msgstr "" 1488 1489#. Tag: refname 1490#: reference_management.xml:897 1491#, no-c-format 1492msgid "UpdateGeometrySRID" 1493msgstr "UpdateGeometrySRID" 1494 1495#. Tag: refpurpose 1496#: reference_management.xml:899 1497#, no-c-format 1498msgid "" 1499"Updates the SRID of all features in a geometry column, geometry_columns " 1500"metadata and srid. If it was enforced with constraints, the constraints will " 1501"be updated with new srid constraint. If the old was enforced by type " 1502"definition, the type definition will be changed." 1503msgstr "" 1504"Met à jour le SRID de toutes les features dans une colonne géométrique, les " 1505"métadonnées de geometry_columns et le srid. Si la vérification par " 1506"contraintes étaient en place, les contraintes sont mises à jour avec le " 1507"nouveau SRID. Si l'ancien SRID était contraint par la définition du type " 1508"(typmod), cette définition sera changée." 1509 1510#. Tag: funcsynopsis 1511#: reference_management.xml:905 1512#, no-c-format 1513msgid "" 1514"<funcprototype> <funcdef>text <function>UpdateGeometrySRID</function></" 1515"funcdef> <paramdef><type>varchar </type> <parameter>table_name</parameter></" 1516"paramdef> <paramdef><type>varchar </type> <parameter>column_name</" 1517"parameter></paramdef> <paramdef><type>integer </type> <parameter>srid</" 1518"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>text " 1519"<function>UpdateGeometrySRID</function></funcdef> <paramdef><type>varchar </" 1520"type> <parameter>schema_name</parameter></paramdef> <paramdef><type>varchar " 1521"</type> <parameter>table_name</parameter></paramdef> <paramdef><type>varchar " 1522"</type> <parameter>column_name</parameter></paramdef> " 1523"<paramdef><type>integer </type> <parameter>srid</parameter></paramdef> </" 1524"funcprototype> <funcprototype> <funcdef>text <function>UpdateGeometrySRID</" 1525"function></funcdef> <paramdef><type>varchar </type> <parameter>catalog_name</" 1526"parameter></paramdef> <paramdef><type>varchar </type> " 1527"<parameter>schema_name</parameter></paramdef> <paramdef><type>varchar </" 1528"type> <parameter>table_name</parameter></paramdef> <paramdef><type>varchar </" 1529"type> <parameter>column_name</parameter></paramdef> <paramdef><type>integer " 1530"</type> <parameter>srid</parameter></paramdef> </funcprototype>" 1531msgstr "" 1532"<funcprototype> <funcdef>text <function>UpdateGeometrySRID</function></" 1533"funcdef> <paramdef><type>varchar </type> <parameter>table_name</parameter></" 1534"paramdef> <paramdef><type>varchar </type> <parameter>column_name</" 1535"parameter></paramdef> <paramdef><type>integer </type> <parameter>srid</" 1536"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>text " 1537"<function>UpdateGeometrySRID</function></funcdef> <paramdef><type>varchar </" 1538"type> <parameter>schema_name</parameter></paramdef> <paramdef><type>varchar " 1539"</type> <parameter>table_name</parameter></paramdef> <paramdef><type>varchar " 1540"</type> <parameter>column_name</parameter></paramdef> " 1541"<paramdef><type>integer </type> <parameter>srid</parameter></paramdef> </" 1542"funcprototype> <funcprototype> <funcdef>text <function>UpdateGeometrySRID</" 1543"function></funcdef> <paramdef><type>varchar </type> <parameter>catalog_name</" 1544"parameter></paramdef> <paramdef><type>varchar </type> " 1545"<parameter>schema_name</parameter></paramdef> <paramdef><type>varchar </" 1546"type> <parameter>table_name</parameter></paramdef> <paramdef><type>varchar </" 1547"type> <parameter>column_name</parameter></paramdef> <paramdef><type>integer " 1548"</type> <parameter>srid</parameter></paramdef> </funcprototype>" 1549 1550#. Tag: para 1551#: reference_management.xml:959 1552#, no-c-format 1553msgid "" 1554"Updates the SRID of all features in a geometry column, updating constraints " 1555"and reference in geometry_columns. Note: uses current_schema() on schema-" 1556"aware pgsql installations if schema is not provided." 1557msgstr "" 1558"Met à jour le SRID de tous les objets d'une colonne géométrique et met à " 1559"jour les métadonnées de geometry_columns et la contrainte sur le SRID. Note: " 1560"utilise la fonction current_schema() sur les installations PostgreSQL le " 1561"supportant, si le schéma n'est pas fourni." 1562 1563#. Tag: para 1564#: reference_management.xml:968 1565#, no-c-format 1566msgid "" 1567"This will change the srid of the roads table to 4326 from whatever it was " 1568"before" 1569msgstr "" 1570"Cela va changer le srid de la table roads à 4326 quelle que soit sa valeur " 1571"avant" 1572 1573#. Tag: programlisting 1574#: reference_management.xml:969 1575#, no-c-format 1576msgid "SELECT UpdateGeometrySRID('roads','geom',4326);" 1577msgstr "SELECT UpdateGeometrySRID('roads','geom',4326);" 1578 1579#. Tag: para 1580#: reference_management.xml:971 1581#, no-c-format 1582msgid "The prior example is equivalent to this DDL statement" 1583msgstr "L'exemple précédent est équivalent à cette requête DDL" 1584 1585#. Tag: programlisting 1586#: reference_management.xml:972 1587#, no-c-format 1588msgid "" 1589"ALTER TABLE roads\n" 1590" ALTER COLUMN geom TYPE geometry(MULTILINESTRING, 4326)\n" 1591" USING ST_SetSRID(geom,4326);" 1592msgstr "" 1593 1594#. Tag: para 1595#: reference_management.xml:974 1596#, no-c-format 1597msgid "" 1598"If you got the projection wrong (or brought it in as unknown) in load and " 1599"you wanted to transform to web mercator all in one shot You can do this with " 1600"DDL but there is no equivalent PostGIS management function to do so in one " 1601"go." 1602msgstr "" 1603"Si vous vous êtes trompé dans la projection lors du chargement ( ou vous " 1604"l'avez insérée comme étant inconnue) et que vous voulez la transformer en " 1605"web mercator en une seule action vous pouvez faire ceci avec des DDL, mais " 1606"il n'y a aucun équivalent PostGIS dans les fonctions de gestion pour faire " 1607"ceci en une seule étape." 1608 1609#. Tag: programlisting 1610#: reference_management.xml:977 1611#, no-c-format 1612msgid "" 1613"ALTER TABLE roads\n" 1614" ALTER COLUMN geom TYPE geometry(MULTILINESTRING, 3857) USING " 1615"ST_Transform(ST_SetSRID(geom,4326),3857) ;" 1616msgstr "" 1617 1618#. Tag: para 1619#: reference_management.xml:982 1620#, no-c-format 1621msgid ", <xref linkend=\"ST_SetSRID\"/>, <xref linkend=\"ST_Transform\"/>" 1622msgstr ", <xref linkend=\"ST_SetSRID\"/>, <xref linkend=\"ST_Transform\"/>" 1623