Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/postgis-workshop/schemas/sv/units/?format=api
{ "count": 36, "next": null, "previous": null, "results": [ { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?format=api", "source": [ "PostgreSQL Schemas" ], "previous_source": "", "target": [ "PostgreSQL-scheman" ], "id_hash": -8886816310691054916, "content_hash": -8886816310691054916, "location": "../../en/schemas.rst:4", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340392, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=04abafa6591cbabc", "url": "https://weblate.osgeo.org/api/units/2340392/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:15.988974Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?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": [ "Produktionsdatabaser har oundvikligen ett stort antal tabeller och vyer, och att hantera dem alla i ett schema kan snabbt bli obehagligt. Lyckligtvis innehåller PostgreSQL_ konceptet \"_Schema\"." ], "id_hash": -1470311288627131034, "content_hash": -1470311288627131034, "location": "../../en/schemas.rst:6", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340393, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=6b9867ac4c220d66", "url": "https://weblate.osgeo.org/api/units/2340393/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:15.992130Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?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": [ "Scheman är som mappar och kan innehålla tabeller, vyer, funktioner, sekvenser och andra relationer. Varje databas börjar med ett schema, det \"offentliga\" schemat." ], "id_hash": -2590022651747296629, "content_hash": -2590022651747296629, "location": "../../en/schemas.rst:8", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340394, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=5c0e641eea631a8b", "url": "https://weblate.osgeo.org/api/units/2340394/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:15.994704Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?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": [ "I det schemat skapar standardinstallationen av PostGIS metadatarelationerna ``geometry_columns``, ``geography_columns`` och ``spatial_ref_sys``, samt alla typer och funktioner som används av PostGIS. Så användare av PostGIS behöver alltid tillgång till det offentliga schemat." ], "id_hash": -1204846504760395790, "content_hash": -1204846504760395790, "location": "../../en/schemas.rst:12", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340395, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=6f47867ccae2b7f2", "url": "https://weblate.osgeo.org/api/units/2340395/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:15.997238Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?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": [ "I det publika schemat kan du också se alla de tabeller som vi har skapat hittills i workshopen." ], "id_hash": 8695137541537991919, "content_hash": 8695137541537991919, "location": "../../en/schemas.rst:14", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340396, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=f8ab558674890cef", "url": "https://weblate.osgeo.org/api/units/2340396/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:15.999803Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?format=api", "source": [ "Why use Schemas?" ], "previous_source": "", "target": [ "Varför använda Schemas?" ], "id_hash": 1052508970105633935, "content_hash": 1052508970105633935, "location": "../../en/schemas.rst:18", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340397, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=8e9b4354f60efc8f", "url": "https://weblate.osgeo.org/api/units/2340397/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.002227Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?format=api", "source": [ "There are two very good reasons for using schemas:" ], "previous_source": "", "target": [ "Det finns två mycket goda skäl till att använda scheman:" ], "id_hash": -1635901640625452398, "content_hash": -1635901640625452398, "location": "../../en/schemas.rst:20", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340398, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=694c1c200f0a8a92", "url": "https://weblate.osgeo.org/api/units/2340398/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.004736Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?format=api", "source": [ "Data that is managed in a schema is easier to apply bulk actions to." ], "previous_source": "", "target": [ "Data som hanteras i ett schema är lättare att använda bulkåtgärder på." ], "id_hash": -3225587216245516428, "content_hash": -3225587216245516428, "location": "../../en/schemas.rst:22", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340399, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=533c698447a51774", "url": "https://weblate.osgeo.org/api/units/2340399/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.007327Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?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": [ "Det är lättare att säkerhetskopiera data som finns i ett separat schema: så flyktiga data kan ha ett annat säkerhetskopieringsschema än icke-flyktiga data." ], "id_hash": 7678548437974895935, "content_hash": 7678548437974895935, "location": "../../en/schemas.rst:24", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340400, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=ea8faf1f241fcd3f", "url": "https://weblate.osgeo.org/api/units/2340400/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.009888Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?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": [ "Det är lättare att återställa data som finns i ett separat schema: så applikationsorienterade scheman kan återställas separat och säkerhetskopieras för tidsresor och återställning." ], "id_hash": -4853520692566493137, "content_hash": -4853520692566493137, "location": "../../en/schemas.rst:25", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340401, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=3ca4d4a52990f82f", "url": "https://weblate.osgeo.org/api/units/2340401/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.012396Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?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": [ "Det är lättare att hantera programskillnader när programdata finns i ett schema: så en ny version av programvaran kan arbeta med en tabellstruktur i ett nytt schema, och övergången innebär en enkel ändring av schemanamnet." ], "id_hash": 4703619327588052336, "content_hash": 4703619327588052336, "location": "../../en/schemas.rst:26", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340402, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=c1469cdb8b8c2d70", "url": "https://weblate.osgeo.org/api/units/2340402/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.015345Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?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": [ "Användare kan begränsas i sitt arbete till enstaka scheman för att möjliggöra isolering av analys- och testtabeller från produktionstabeller." ], "id_hash": -1816223157841303210, "content_hash": -1816223157841303210, "location": "../../en/schemas.rst:28", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340403, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=66cb7aa92407e956", "url": "https://weblate.osgeo.org/api/units/2340403/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.018063Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?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": [ "Så för produktionsändamål förbättras hanteringen om du håller dina applikationsdata åtskilda i scheman; och för användarändamål förhindrar du att dina användare trampar på varandra genom att hålla dem i separata scheman." ], "id_hash": 212467821786474283, "content_hash": 212467821786474283, "location": "../../en/schemas.rst:30", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340404, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=82f2d65bb3c8a72b", "url": "https://weblate.osgeo.org/api/units/2340404/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.020621Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?format=api", "source": [ "Creating a Data Schema" ], "previous_source": "", "target": [ "Skapa ett dataschema" ], "id_hash": 7568461229420045468, "content_hash": 7568461229420045468, "location": "../../en/schemas.rst:34", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340405, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=e908936383e5e49c", "url": "https://weblate.osgeo.org/api/units/2340405/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.023266Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?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": [ "Låt oss skapa ett nytt schema och flytta en tabell till det. Skapa först ett nytt schema i databasen:" ], "id_hash": -279613405728732838, "content_hash": -279613405728732838, "location": "../../en/schemas.rst:36", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340406, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=7c1e9d16c51a095a", "url": "https://weblate.osgeo.org/api/units/2340406/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.025868Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?format=api", "source": [ "Next, we will move the ``nyc_census_blocks`` table to the ``census`` schema:" ], "previous_source": "", "target": [ "Därefter flyttar vi tabellen ``nyc_census_blocks`` till schemat ``census``:" ], "id_hash": 8464045524879258247, "content_hash": 8464045524879258247, "location": "../../en/schemas.rst:42", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340407, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=f576548f7929b287", "url": "https://weblate.osgeo.org/api/units/2340407/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.028995Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?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": [ "Om du använder kommandoradsprogrammet :command:`psql` kommer du att märka att ``nyc_census_blocks`` har försvunnit från din tabellista nu! Om du använder PgAdmin kan du behöva uppdatera din vy för att se det nya schemat och tabellen i det." ], "id_hash": 1436805870175200359, "content_hash": 1436805870175200359, "location": "../../en/schemas.rst:48", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340408, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=93f08f538efd2467", "url": "https://weblate.osgeo.org/api/units/2340408/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.031621Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?format=api", "source": [ "You can access tables inside schemas in two ways:" ], "previous_source": "", "target": [ "Du kan komma åt tabeller i scheman på två sätt:" ], "id_hash": -8600915504822134896, "content_hash": -8600915504822134896, "location": "../../en/schemas.rst:50", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340409, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=08a368eaffed5790", "url": "https://weblate.osgeo.org/api/units/2340409/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.034408Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?format=api", "source": [ "by referencing them using ``schema.table`` notation" ], "previous_source": "", "target": [ "genom att referera till dem med hjälp av ``schema.table``-notation" ], "id_hash": 4184222717610201623, "content_hash": 4184222717610201623, "location": "../../en/schemas.rst:52", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340410, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=ba11586488469217", "url": "https://weblate.osgeo.org/api/units/2340410/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.037003Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?format=api", "source": [ "by adding the schema to your ``search_path``" ], "previous_source": "", "target": [ "genom att lägga till schemat i din ``search_path``" ], "id_hash": 788069461238815375, "content_hash": 788069461238815375, "location": "../../en/schemas.rst:53", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340411, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=8aefc8ffe7791a8f", "url": "https://weblate.osgeo.org/api/units/2340411/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.039614Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?format=api", "source": [ "Explicit referencing is easy, but it gets tiring to type after a while:" ], "previous_source": "", "target": [ "Explicit hänvisning är enkelt, men det blir tröttsamt att skriva efter ett tag:" ], "id_hash": 5451639701760265941, "content_hash": 5451639701760265941, "location": "../../en/schemas.rst:55", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340412, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=cba81d6cbad64ed5", "url": "https://weblate.osgeo.org/api/units/2340412/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.042221Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?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": [ "Manipulering av ``search_path`` är ett bra sätt att ge åtkomst till tabeller i flera scheman utan en massa extra typning." ], "id_hash": -8766865489712415021, "content_hash": -8766865489712415021, "location": "../../en/schemas.rst:61", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340413, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=0655d649340f7ed3", "url": "https://weblate.osgeo.org/api/units/2340413/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.044661Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?format=api", "source": [ "You can set the ``search_path`` at run time using the ``SET`` command:" ], "previous_source": "", "target": [ "Du kan ställa in ``search_path`` vid körning med kommandot ``SET``:" ], "id_hash": 6261257118765750880, "content_hash": 6261257118765750880, "location": "../../en/schemas.rst:63", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340414, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=d6e4742d0b6b1a60", "url": "https://weblate.osgeo.org/api/units/2340414/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.047440Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?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": [ "Detta säkerställer att alla referenser till relationer och funktioner söks i både ``census`` och ``public`` schemat. Kom ihåg att alla PostGIS-funktioner och -typer finns i ``public`` så vi vill inte ta bort dem från sökvägen." ], "id_hash": -7875221711749531039, "content_hash": -7875221711749531039, "location": "../../en/schemas.rst:69", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340415, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=12b59793efb9ba61", "url": "https://weblate.osgeo.org/api/units/2340415/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.050041Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?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": [ "Att ställa in sökvägen varje gång du ansluter kan också bli tröttsamt, men lyckligtvis är det möjligt att permanent ställa in sökvägen för en användare:" ], "id_hash": -2639337842923577153, "content_hash": -2639337842923577153, "location": "../../en/schemas.rst:71", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340416, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=5b5f3037364b60bf", "url": "https://weblate.osgeo.org/api/units/2340416/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.052698Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?format=api", "source": [ "Now the postgres user will always have the ``census`` schema in their search path." ], "previous_source": "", "target": [ "Nu kommer postgres-användaren alltid att ha schemat ``census`` i sin sökväg." ], "id_hash": -4405374113662166495, "content_hash": -4405374113662166495, "location": "../../en/schemas.rst:77", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340417, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=42dcf79594771a21", "url": "https://weblate.osgeo.org/api/units/2340417/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.055382Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?format=api", "source": [ "Creating a User Schema" ], "previous_source": "", "target": [ "Skapa ett användarschema" ], "id_hash": 3047927684053294564, "content_hash": 3047927684053294564, "location": "../../en/schemas.rst:81", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340418, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=aa4c6a147d135de4", "url": "https://weblate.osgeo.org/api/units/2340418/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.057995Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?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": [ "Användare gillar att skapa tabeller, och PostGIS-användare gör det särskilt: analysoperationer med SQL kräver temporära tabeller för visualisering eller tillfälliga resultat, så spatial SQL tenderar att kräva att användare har CREATE-rättigheter mer än vanliga databasarbetsbelastningar." ], "id_hash": -2034115669987581779, "content_hash": -2034115669987581779, "location": "../../en/schemas.rst:83", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340419, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=63c55e934a55a0ad", "url": "https://weblate.osgeo.org/api/units/2340419/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.060626Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?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": [ "Som standard får varje roll i Oracle ett personligt schema. Detta är en trevlig praxis att använda för PostgreSQL-användare också, och det är lätt att replikera med PostgreSQL-roller, scheman och sökvägar." ], "id_hash": -1237469761498094955, "content_hash": -1237469761498094955, "location": "../../en/schemas.rst:85", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340420, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=6ed39fceed9e6295", "url": "https://weblate.osgeo.org/api/units/2340420/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.063255Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?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": [ "Skapa en ny användare med behörighet att skapa tabeller (se :ref:`security` för information om rollen ``postgis_writer``) och skapa sedan ett schema med den användaren som behörig:" ], "id_hash": 6955049323959501885, "content_hash": 6955049323959501885, "location": "../../en/schemas.rst:87", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340421, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=e0854c82bded443d", "url": "https://weblate.osgeo.org/api/units/2340421/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.065838Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?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": [ "Om du loggar in som den användaren kommer du att upptäcka att standard ``search_path`` för PostgreSQL faktiskt är detta:" ], "id_hash": 7750240245039702294, "content_hash": 7750240245039702294, "location": "../../en/schemas.rst:94", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340422, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=eb8e6270b9872116", "url": "https://weblate.osgeo.org/api/units/2340422/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.068373Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?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": [ "Det första schemat på sökvägen är användarens namngivna schema! Så nu finns följande villkor:" ], "id_hash": 3280979363715958380, "content_hash": 3280979363715958380, "location": "../../en/schemas.rst:106", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340423, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=ad88615911ad466c", "url": "https://weblate.osgeo.org/api/units/2340423/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.070951Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?format=api", "source": [ "The user exists, with the ability to create spatial tables." ], "previous_source": "", "target": [ "Användaren finns, med möjlighet att skapa spatiala tabeller." ], "id_hash": -2722499917199656732, "content_hash": -2722499917199656732, "location": "../../en/schemas.rst:108", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340424, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=5a37bcbfee48b8e4", "url": "https://weblate.osgeo.org/api/units/2340424/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.073464Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?format=api", "source": [ "The user's named schema exists, and the user owns it." ], "previous_source": "", "target": [ "Användarens namngivna schema finns och användaren äger det." ], "id_hash": 1323214385234670449, "content_hash": 1323214385234670449, "location": "../../en/schemas.rst:109", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340425, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=925d007901997371", "url": "https://weblate.osgeo.org/api/units/2340425/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.076997Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?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": [ "Användarens sökväg har användarens schema först, så nya tabeller skapas automatiskt där och frågor söker automatiskt där först." ], "id_hash": 4302773267715094602, "content_hash": 4302773267715094602, "location": "../../en/schemas.rst:110", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340426, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=bbb6857d6b34784a", "url": "https://weblate.osgeo.org/api/units/2340426/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.079526Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?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": [ "Det är allt som behövs, användarens standardarbetsområde är nu snyggt separerat från alla tabeller i andra scheman." ], "id_hash": 898247385090668541, "content_hash": 898247385090668541, "location": "../../en/schemas.rst:112", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 2340427, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/sv/?checksum=8c77373cd4c0b7fd", "url": "https://weblate.osgeo.org/api/units/2340427/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T15:19:16.082113Z" } ] }