summaryrefslogtreecommitdiffstats
path: root/helpcontent2/source/text/sdatabase/dabawiz02pgsql.xhp
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-04-07 09:06:44 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-04-07 09:06:44 +0000
commited5640d8b587fbcfed7dd7967f3de04b37a76f26 (patch)
tree7a5f7c6c9d02226d7471cb3cc8fbbf631b415303 /helpcontent2/source/text/sdatabase/dabawiz02pgsql.xhp
parentInitial commit. (diff)
downloadlibreoffice-upstream.tar.xz
libreoffice-upstream.zip
Adding upstream version 4:7.4.7.upstream/4%7.4.7upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'helpcontent2/source/text/sdatabase/dabawiz02pgsql.xhp')
-rw-r--r--helpcontent2/source/text/sdatabase/dabawiz02pgsql.xhp50
1 files changed, 50 insertions, 0 deletions
diff --git a/helpcontent2/source/text/sdatabase/dabawiz02pgsql.xhp b/helpcontent2/source/text/sdatabase/dabawiz02pgsql.xhp
new file mode 100644
index 000000000..60bd1011e
--- /dev/null
+++ b/helpcontent2/source/text/sdatabase/dabawiz02pgsql.xhp
@@ -0,0 +1,50 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+ <!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ -->
+
+ <meta>
+ <topic id="textsdatabasedabawiz02pgsqlxml" indexer="include" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">PostgreSQL Connection</title>
+ <filename>/text/sdatabase/dabawiz02pgsql.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+ <bookmark xml-lang="en-US" branch="index" id="bm_id861587404584956">
+<bookmark_value>PostgreSQL settings (Base)</bookmark_value>
+ </bookmark>
+ <bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbwizconnectionpage/ConnectionPage" id="bm_id701643051950111" localize="false"/>
+ <section id="pgsqlHead">
+ <h1 id="hd_id971643043442131"><variable id="pgsqlh1"><link href="text/sdatabase/dabawiz02pgsql.xhp" name="pgconnection">PostgreSQL Connection</link></variable></h1>
+ <paragraph id="par_id811643043442133" role="paragraph" xml-lang="en-US">Specifies the options for connecting to PostgreSQL databases.</paragraph>
+ </section>
+ <h2 id="hd_id321643044241406">DBMS/driver-specific connection string</h2>
+ <paragraph role="paragraph" id="par_id341643044249556">Enter the driver specific connection string. The connection string is sequence of keyword/value pairs separated by spaces. For example</paragraph>
+ <paragraph role="paragraph" id="par_id471643044279530"><literal>dbname=MyDatabase host=myHost port=5432</literal></paragraph>
+ <paragraph role="paragraph" id="par_id301643045873140">where</paragraph>
+ <list type="unordered">
+ <listitem>
+ <paragraph id="par_id511643044303340" role="listitem"><emph>dbname</emph>: the name of the database hosted in the DBMS server.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id331643044364699" role="listitem"><emph>host</emph>: the fully qualified name of the RDBMS server</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id931643044367236" role="listitem"><emph>port</emph>: the server port. The default port for PostgreSQL is 5432.</paragraph>
+ </listitem>
+ </list>
+ <paragraph role="paragraph" id="par_id421643049901759">You can also enter the connection string as</paragraph> <paragraph role="paragraph" id="par_id51643050033680"><literal>postgresql://myHost:port/MyDatabase</literal>.</paragraph>
+
+ <note id="par_id71643046088031">Refer to the database server administrator for the correct values of the keywords passed in the connection string. Values for <emph>user=</emph> and <emph>password=</emph> are ignored but will be requested at connection time.</note>
+ <tip id="par_id131643048856194">The connection string is displayed in the %PRODUCTNAME Base status bar.</tip>
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id571643046067450">List of all keyword/value pairs for <link href="https://www.postgresql.org/docs/13/libpq-connect.html#LIBPQ-PARAMKEYWORDS" name="PG13keywords">PostgreSQL 13</link> connection string. Not every pair is handled by the %PRODUCTNAME driver manager.</paragraph>
+ </section>
+</body>
+</helpdocument>