diff options
| -rw-r--r-- | AllLangHelp_sdatabase.mk | 1 | ||||
| -rw-r--r-- | source/text/sdatabase/dabawiz01.xhp | 1 | ||||
| -rw-r--r-- | source/text/sdatabase/dabawiz02pgsql.xhp | 50 |
3 files changed, 52 insertions, 0 deletions
diff --git a/AllLangHelp_sdatabase.mk b/AllLangHelp_sdatabase.mk index fec5f43b94..b715812eec 100644 --- a/AllLangHelp_sdatabase.mk +++ b/AllLangHelp_sdatabase.mk @@ -66,6 +66,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,sdatabase,\ helpcontent2/source/text/sdatabase/dabawiz02jdbc \ helpcontent2/source/text/sdatabase/dabawiz02mysql \ helpcontent2/source/text/sdatabase/dabawiz02odbc \ + helpcontent2/source/text/sdatabase/dabawiz02pgsql \ helpcontent2/source/text/sdatabase/dabawiz02oracle \ helpcontent2/source/text/sdatabase/dabawiz02spreadsheet \ helpcontent2/source/text/sdatabase/dabawiz02text \ diff --git a/source/text/sdatabase/dabawiz01.xhp b/source/text/sdatabase/dabawiz01.xhp index 2da4272741..0a8b98b8ec 100644 --- a/source/text/sdatabase/dabawiz01.xhp +++ b/source/text/sdatabase/dabawiz01.xhp @@ -64,6 +64,7 @@ <paragraph role="paragraph" id="par_idN10667" xml-lang="en-US"><link href="text/sdatabase/dabawiz02jdbc.xhp">Set up JDBC connection</link></paragraph> <paragraph role="paragraph" id="par_idN10676" xml-lang="en-US"><link href="text/sdatabase/dabawiz02oracle.xhp">Set up Oracle database connection</link></paragraph> <embed href="text/sdatabase/dabawiz02mysql.xhp#mysql"/> +<embed href="text/sdatabase/dabawiz02pgsql.xhp#pgsqlh1"/> <paragraph role="paragraph" id="par_idN10694" xml-lang="en-US"><link href="text/sdatabase/dabawiz02odbc.xhp">ODBC settings</link></paragraph> <paragraph role="paragraph" id="par_idN106A3" xml-lang="en-US"><link href="text/sdatabase/dabawiz02spreadsheet.xhp">Set up Spreadsheet connection</link></paragraph> </body> diff --git a/source/text/sdatabase/dabawiz02pgsql.xhp b/source/text/sdatabase/dabawiz02pgsql.xhp new file mode 100644 index 0000000000..91a2f0aa25 --- /dev/null +++ b/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">PostgresSQL 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">PostgresSQL Connection</link></variable></h1> + <paragraph id="par_id811643043442133" role="paragraph" xml-lang="en-US">Specifies the options for connecting to PostgresSQL 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">PostgresSQL 13</link> connection string. Not every pair is handled by the %PRODUCTNAME driver manager.</paragraph> + </section> +</body> +</helpdocument> |