Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/postgis-workshop/schemas/en/units/?format=api
{ "count": 36, "next": null, "previous": null, "results": [ { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "PostgreSQL Schemas" ], "previous_source": "", "target": [ "PostgreSQL Schemas" ], "id_hash": -8886816310691054916, "content_hash": -8886816310691054916, "location": "../../en/schemas.rst:4", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/98038/?format=api", "priority": 100, "id": 98038, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=04abafa6591cbabc", "url": "https://weblate.osgeo.org/api/units/98038/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.162752Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Production databases inevitably have a large number of tables and views, and managing them all in one schema can become unwieldy quickly. Fortunately, PostgreSQL_ includes the concept of a \"_Schema\"." ], "previous_source": "", "target": [ "Production databases inevitably have a large number of tables and views, and managing them all in one schema can become unwieldy quickly. Fortunately, PostgreSQL_ includes the concept of a \"_Schema\"." ], "id_hash": -1470311288627131034, "content_hash": -1470311288627131034, "location": "../../en/schemas.rst:6", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 2, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://weblate.osgeo.org/api/units/98039/?format=api", "priority": 100, "id": 98039, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=6b9867ac4c220d66", "url": "https://weblate.osgeo.org/api/units/98039/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.194562Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Schemas are like folders, and can hold tables, views, functions, sequences and other relations. Every database starts out with one schema, the ``public`` schema." ], "previous_source": "", "target": [ "Schemas are like folders, and can hold tables, views, functions, sequences and other relations. Every database starts out with one schema, the ``public`` schema." ], "id_hash": -2590022651747296629, "content_hash": -2590022651747296629, "location": "../../en/schemas.rst:8", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 3, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://weblate.osgeo.org/api/units/98040/?format=api", "priority": 100, "id": 98040, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=5c0e641eea631a8b", "url": "https://weblate.osgeo.org/api/units/98040/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.218545Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Inside that schema, the default install of PostGIS creates the ``geometry_columns``, ``geography_columns`` and ``spatial_ref_sys`` metadata relations, as well as all the types and functions used by PostGIS. So users of PostGIS always need access to the public schema." ], "previous_source": "", "target": [ "Inside that schema, the default install of PostGIS creates the ``geometry_columns``, ``geography_columns`` and ``spatial_ref_sys`` metadata relations, as well as all the types and functions used by PostGIS. So users of PostGIS always need access to the public schema." ], "id_hash": -1204846504760395790, "content_hash": -1204846504760395790, "location": "../../en/schemas.rst:12", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 4, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://weblate.osgeo.org/api/units/98041/?format=api", "priority": 100, "id": 98041, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=6f47867ccae2b7f2", "url": "https://weblate.osgeo.org/api/units/98041/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.242215Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "In the public schema you can also see all the tables we have created so far in the workshop." ], "previous_source": "", "target": [ "In the public schema you can also see all the tables we have created so far in the workshop." ], "id_hash": 8695137541537991919, "content_hash": 8695137541537991919, "location": "../../en/schemas.rst:14", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 5, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://weblate.osgeo.org/api/units/98042/?format=api", "priority": 100, "id": 98042, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=f8ab558674890cef", "url": "https://weblate.osgeo.org/api/units/98042/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.267188Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Why use Schemas?" ], "previous_source": "", "target": [ "Why use Schemas?" ], "id_hash": 1052508970105633935, "content_hash": 1052508970105633935, "location": "../../en/schemas.rst:18", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 6, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/98043/?format=api", "priority": 100, "id": 98043, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=8e9b4354f60efc8f", "url": "https://weblate.osgeo.org/api/units/98043/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.296004Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "There are two very good reasons for using schemas:" ], "previous_source": "", "target": [ "There are two very good reasons for using schemas:" ], "id_hash": -1635901640625452398, "content_hash": -1635901640625452398, "location": "../../en/schemas.rst:20", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 7, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://weblate.osgeo.org/api/units/98044/?format=api", "priority": 100, "id": 98044, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=694c1c200f0a8a92", "url": "https://weblate.osgeo.org/api/units/98044/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.321887Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Data that is managed in a schema is easier to apply bulk actions to." ], "previous_source": "", "target": [ "Data that is managed in a schema is easier to apply bulk actions to." ], "id_hash": -3225587216245516428, "content_hash": -3225587216245516428, "location": "../../en/schemas.rst:22", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 8, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://weblate.osgeo.org/api/units/98045/?format=api", "priority": 100, "id": 98045, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=533c698447a51774", "url": "https://weblate.osgeo.org/api/units/98045/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.345452Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "It's easier to back-up data that's in a separate schema: so volatile data can have a different back-up schedule from non-volatile data." ], "previous_source": "", "target": [ "It's easier to back-up data that's in a separate schema: so volatile data can have a different back-up schedule from non-volatile data." ], "id_hash": 7678548437974895935, "content_hash": 7678548437974895935, "location": "../../en/schemas.rst:24", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 9, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://weblate.osgeo.org/api/units/98047/?format=api", "priority": 100, "id": 98047, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=ea8faf1f241fcd3f", "url": "https://weblate.osgeo.org/api/units/98047/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.368502Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "It's easier to restore data that's in a separate schema: so application-oriented schemas can be separately restored and backed up for time travel and recovery." ], "previous_source": "", "target": [ "It's easier to restore data that's in a separate schema: so application-oriented schemas can be separately restored and backed up for time travel and recovery." ], "id_hash": -4853520692566493137, "content_hash": -4853520692566493137, "location": "../../en/schemas.rst:25", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 10, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://weblate.osgeo.org/api/units/98048/?format=api", "priority": 100, "id": 98048, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=3ca4d4a52990f82f", "url": "https://weblate.osgeo.org/api/units/98048/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.392010Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "It's easier to manage application differences when the application data is in a schema: so a new version of software can work off a table structure in a new schema, and cut-over involves a simple change to the schema name." ], "previous_source": "", "target": [ "It's easier to manage application differences when the application data is in a schema: so a new version of software can work off a table structure in a new schema, and cut-over involves a simple change to the schema name." ], "id_hash": 4703619327588052336, "content_hash": 4703619327588052336, "location": "../../en/schemas.rst:26", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 11, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://weblate.osgeo.org/api/units/98050/?format=api", "priority": 100, "id": 98050, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=c1469cdb8b8c2d70", "url": "https://weblate.osgeo.org/api/units/98050/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.414757Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Users can be restricted in their work to single schemas to allow isolation of analytical and test tables from production tables." ], "previous_source": "", "target": [ "Users can be restricted in their work to single schemas to allow isolation of analytical and test tables from production tables." ], "id_hash": -1816223157841303210, "content_hash": -1816223157841303210, "location": "../../en/schemas.rst:28", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 12, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://weblate.osgeo.org/api/units/98053/?format=api", "priority": 100, "id": 98053, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=66cb7aa92407e956", "url": "https://weblate.osgeo.org/api/units/98053/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.438085Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "So for production purposes, keeping your application data separate in schemas improves management; and for user purposes, keeping your users in separate schemas keeps them from treading on each other." ], "previous_source": "", "target": [ "So for production purposes, keeping your application data separate in schemas improves management; and for user purposes, keeping your users in separate schemas keeps them from treading on each other." ], "id_hash": 212467821786474283, "content_hash": 212467821786474283, "location": "../../en/schemas.rst:30", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 13, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://weblate.osgeo.org/api/units/98056/?format=api", "priority": 100, "id": 98056, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=82f2d65bb3c8a72b", "url": "https://weblate.osgeo.org/api/units/98056/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.461286Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Creating a Data Schema" ], "previous_source": "", "target": [ "Creating a Data Schema" ], "id_hash": 7568461229420045468, "content_hash": 7568461229420045468, "location": "../../en/schemas.rst:34", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 14, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://weblate.osgeo.org/api/units/98060/?format=api", "priority": 100, "id": 98060, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=e908936383e5e49c", "url": "https://weblate.osgeo.org/api/units/98060/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.484667Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Let's create a new schema and move a table into it. First, create a new schema in the database:" ], "previous_source": "", "target": [ "Let's create a new schema and move a table into it. First, create a new schema in the database:" ], "id_hash": -279613405728732838, "content_hash": -279613405728732838, "location": "../../en/schemas.rst:36", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 15, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://weblate.osgeo.org/api/units/98063/?format=api", "priority": 100, "id": 98063, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=7c1e9d16c51a095a", "url": "https://weblate.osgeo.org/api/units/98063/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.507567Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Next, we will move the ``nyc_census_blocks`` table to the ``census`` schema:" ], "previous_source": "", "target": [ "Next, we will move the ``nyc_census_blocks`` table to the ``census`` schema:" ], "id_hash": 8464045524879258247, "content_hash": 8464045524879258247, "location": "../../en/schemas.rst:42", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 16, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://weblate.osgeo.org/api/units/98067/?format=api", "priority": 100, "id": 98067, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=f576548f7929b287", "url": "https://weblate.osgeo.org/api/units/98067/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.530535Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "If you're using the :command:`psql` command-line program, you'll notice that ``nyc_census_blocks`` has disappeared from your table listing now! If you're using PgAdmin, you might have to refresh your view to see the new schema and the table inside it." ], "previous_source": "", "target": [ "If you're using the :command:`psql` command-line program, you'll notice that ``nyc_census_blocks`` has disappeared from your table listing now! If you're using PgAdmin, you might have to refresh your view to see the new schema and the table inside it." ], "id_hash": 1436805870175200359, "content_hash": 1436805870175200359, "location": "../../en/schemas.rst:48", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 17, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://weblate.osgeo.org/api/units/98071/?format=api", "priority": 100, "id": 98071, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=93f08f538efd2467", "url": "https://weblate.osgeo.org/api/units/98071/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.553213Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "You can access tables inside schemas in two ways:" ], "previous_source": "", "target": [ "You can access tables inside schemas in two ways:" ], "id_hash": -8600915504822134896, "content_hash": -8600915504822134896, "location": "../../en/schemas.rst:50", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 18, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://weblate.osgeo.org/api/units/98075/?format=api", "priority": 100, "id": 98075, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=08a368eaffed5790", "url": "https://weblate.osgeo.org/api/units/98075/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.576555Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "by referencing them using ``schema.table`` notation" ], "previous_source": "", "target": [ "by referencing them using ``schema.table`` notation" ], "id_hash": 4184222717610201623, "content_hash": 4184222717610201623, "location": "../../en/schemas.rst:52", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 19, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://weblate.osgeo.org/api/units/98079/?format=api", "priority": 100, "id": 98079, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=ba11586488469217", "url": "https://weblate.osgeo.org/api/units/98079/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.599383Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "by adding the schema to your ``search_path``" ], "previous_source": "", "target": [ "by adding the schema to your ``search_path``" ], "id_hash": 788069461238815375, "content_hash": 788069461238815375, "location": "../../en/schemas.rst:53", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 20, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://weblate.osgeo.org/api/units/98083/?format=api", "priority": 100, "id": 98083, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=8aefc8ffe7791a8f", "url": "https://weblate.osgeo.org/api/units/98083/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.622173Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Explicit referencing is easy, but it gets tiring to type after a while:" ], "previous_source": "", "target": [ "Explicit referencing is easy, but it gets tiring to type after a while:" ], "id_hash": 5451639701760265941, "content_hash": 5451639701760265941, "location": "../../en/schemas.rst:55", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 21, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://weblate.osgeo.org/api/units/98087/?format=api", "priority": 100, "id": 98087, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=cba81d6cbad64ed5", "url": "https://weblate.osgeo.org/api/units/98087/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.645506Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Manipulating the ``search_path`` is a nice way to provide access to tables in multiple schemas without lots of extra typing." ], "previous_source": "", "target": [ "Manipulating the ``search_path`` is a nice way to provide access to tables in multiple schemas without lots of extra typing." ], "id_hash": -8766865489712415021, "content_hash": -8766865489712415021, "location": "../../en/schemas.rst:61", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 22, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://weblate.osgeo.org/api/units/98091/?format=api", "priority": 100, "id": 98091, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=0655d649340f7ed3", "url": "https://weblate.osgeo.org/api/units/98091/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.668292Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "You can set the ``search_path`` at run time using the ``SET`` command:" ], "previous_source": "", "target": [ "You can set the ``search_path`` at run time using the ``SET`` command:" ], "id_hash": 6261257118765750880, "content_hash": 6261257118765750880, "location": "../../en/schemas.rst:63", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 23, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://weblate.osgeo.org/api/units/98095/?format=api", "priority": 100, "id": 98095, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=d6e4742d0b6b1a60", "url": "https://weblate.osgeo.org/api/units/98095/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.690962Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "This ensures that all references to relations and functions are searched in both the ``census`` and the ``public`` schemas. Remember that all the PostGIS functions and types are in ``public`` so we don't want to drop that from the search path." ], "previous_source": "", "target": [ "This ensures that all references to relations and functions are searched in both the ``census`` and the ``public`` schemas. Remember that all the PostGIS functions and types are in ``public`` so we don't want to drop that from the search path." ], "id_hash": -7875221711749531039, "content_hash": -7875221711749531039, "location": "../../en/schemas.rst:69", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 24, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://weblate.osgeo.org/api/units/98099/?format=api", "priority": 100, "id": 98099, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=12b59793efb9ba61", "url": "https://weblate.osgeo.org/api/units/98099/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.713230Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Setting the search path every time you connect can get tiring too, but fortunately it's possible to permanently set the search path for a user:" ], "previous_source": "", "target": [ "Setting the search path every time you connect can get tiring too, but fortunately it's possible to permanently set the search path for a user:" ], "id_hash": -2639337842923577153, "content_hash": -2639337842923577153, "location": "../../en/schemas.rst:71", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 25, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://weblate.osgeo.org/api/units/98103/?format=api", "priority": 100, "id": 98103, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=5b5f3037364b60bf", "url": "https://weblate.osgeo.org/api/units/98103/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.735679Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Now the postgres user will always have the ``census`` schema in their search path." ], "previous_source": "", "target": [ "Now the postgres user will always have the ``census`` schema in their search path." ], "id_hash": -4405374113662166495, "content_hash": -4405374113662166495, "location": "../../en/schemas.rst:77", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 26, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://weblate.osgeo.org/api/units/98107/?format=api", "priority": 100, "id": 98107, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=42dcf79594771a21", "url": "https://weblate.osgeo.org/api/units/98107/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.758033Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Creating a User Schema" ], "previous_source": "", "target": [ "Creating a User Schema" ], "id_hash": 3047927684053294564, "content_hash": 3047927684053294564, "location": "../../en/schemas.rst:81", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 27, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://weblate.osgeo.org/api/units/98111/?format=api", "priority": 100, "id": 98111, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=aa4c6a147d135de4", "url": "https://weblate.osgeo.org/api/units/98111/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.779867Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Users like to create tables, and PostGIS users do so particularly: analysis operations with SQL demand temporary tables for visualization or interim results, so spatial SQL tends to require that users have CREATE privileges more than ordinary database workloads." ], "previous_source": "", "target": [ "Users like to create tables, and PostGIS users do so particularly: analysis operations with SQL demand temporary tables for visualization or interim results, so spatial SQL tends to require that users have CREATE privileges more than ordinary database workloads." ], "id_hash": -2034115669987581779, "content_hash": -2034115669987581779, "location": "../../en/schemas.rst:83", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 28, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://weblate.osgeo.org/api/units/98115/?format=api", "priority": 100, "id": 98115, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=63c55e934a55a0ad", "url": "https://weblate.osgeo.org/api/units/98115/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.802307Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "By default, every role in Oracle is given a personal schema. This is a nice practice to use for PostgreSQL users too, and is easy to replicate using PostgreSQL roles, schemas, and search paths." ], "previous_source": "", "target": [ "By default, every role in Oracle is given a personal schema. This is a nice practice to use for PostgreSQL users too, and is easy to replicate using PostgreSQL roles, schemas, and search paths." ], "id_hash": -1237469761498094955, "content_hash": -1237469761498094955, "location": "../../en/schemas.rst:85", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 29, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://weblate.osgeo.org/api/units/98119/?format=api", "priority": 100, "id": 98119, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=6ed39fceed9e6295", "url": "https://weblate.osgeo.org/api/units/98119/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.824693Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Create a new user with table creation privileges (see :ref:`security` for information about the ``postgis_writer`` role), then create a schema with that user as the authorization:" ], "previous_source": "", "target": [ "Create a new user with table creation privileges (see :ref:`security` for information about the ``postgis_writer`` role), then create a schema with that user as the authorization:" ], "id_hash": 6955049323959501885, "content_hash": 6955049323959501885, "location": "../../en/schemas.rst:87", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 30, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://weblate.osgeo.org/api/units/98123/?format=api", "priority": 100, "id": 98123, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=e0854c82bded443d", "url": "https://weblate.osgeo.org/api/units/98123/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.847230Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "If you log in as that user, you'll find the default ``search_path`` for PostgreSQL is actually this:" ], "previous_source": "", "target": [ "If you log in as that user, you'll find the default ``search_path`` for PostgreSQL is actually this:" ], "id_hash": 7750240245039702294, "content_hash": 7750240245039702294, "location": "../../en/schemas.rst:94", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 31, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://weblate.osgeo.org/api/units/98127/?format=api", "priority": 100, "id": 98127, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=eb8e6270b9872116", "url": "https://weblate.osgeo.org/api/units/98127/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.869285Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "The first schema on the search path us the user's named schema! So now the following conditions exist:" ], "previous_source": "", "target": [ "The first schema on the search path us the user's named schema! So now the following conditions exist:" ], "id_hash": 3280979363715958380, "content_hash": 3280979363715958380, "location": "../../en/schemas.rst:106", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 32, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://weblate.osgeo.org/api/units/98131/?format=api", "priority": 100, "id": 98131, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=ad88615911ad466c", "url": "https://weblate.osgeo.org/api/units/98131/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.891050Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "The user exists, with the ability to create spatial tables." ], "previous_source": "", "target": [ "The user exists, with the ability to create spatial tables." ], "id_hash": -2722499917199656732, "content_hash": -2722499917199656732, "location": "../../en/schemas.rst:108", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 33, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://weblate.osgeo.org/api/units/98134/?format=api", "priority": 100, "id": 98134, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=5a37bcbfee48b8e4", "url": "https://weblate.osgeo.org/api/units/98134/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.913147Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "The user's named schema exists, and the user owns it." ], "previous_source": "", "target": [ "The user's named schema exists, and the user owns it." ], "id_hash": 1323214385234670449, "content_hash": 1323214385234670449, "location": "../../en/schemas.rst:109", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 34, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://weblate.osgeo.org/api/units/98137/?format=api", "priority": 100, "id": 98137, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=925d007901997371", "url": "https://weblate.osgeo.org/api/units/98137/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.934975Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "The user's search path has the user schema first, so new tables are automatically created there, and queries automatically search there first." ], "previous_source": "", "target": [ "The user's search path has the user schema first, so new tables are automatically created there, and queries automatically search there first." ], "id_hash": 4302773267715094602, "content_hash": 4302773267715094602, "location": "../../en/schemas.rst:110", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 35, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://weblate.osgeo.org/api/units/98140/?format=api", "priority": 100, "id": 98140, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=bbb6857d6b34784a", "url": "https://weblate.osgeo.org/api/units/98140/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.957059Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "That's all there is to it, the user's default work area is now nicely separated from any tables in other schemas." ], "previous_source": "", "target": [ "That's all there is to it, the user's default work area is now nicely separated from any tables in other schemas." ], "id_hash": 898247385090668541, "content_hash": 898247385090668541, "location": "../../en/schemas.rst:112", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 36, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://weblate.osgeo.org/api/units/98142/?format=api", "priority": 100, "id": 98142, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=8c77373cd4c0b7fd", "url": "https://weblate.osgeo.org/api/units/98142/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.979911Z" } ] }