Re: [libreoffice-users] Need help with Base

On 05/06/2014 02:37 PM, Wolfgang Keller wrote:
> > may I ask a question in line with that thread:
> >
> > a few month ago, I failed installing LO-base with PostgreSQL-DB when
> > I stumbled over the input request
> > URL of data source ?
> Since the PostgreSQL SDBC driver uses the native PostgreSQL protocol
> (way more efficient than such kludgy crutches as ODBC or JDBC), the
> connection string would have to look like this (one line, pairs of
> key=value, separated by a space):
>
> dbname=your_database_name hostaddr=127.0.0.1 port=5432
> user=your_database_user password=your_password
>
> Here we are connecting to localhost (127.0.0.1).
>
> > What format should that URL have?
> > Some examples of formally correct URL would help.
> > What is a possible correct driver name?
> The PostgreSQL documentation lists all available options for the
> connection string:
>
> http://www.postgresql.org/docs/9.3/static/libpq-connect.html
>
> in section 31.1.1. Connection Strings.
>
> I don't have a clue how to connect to a specific schema within a
> PostgreSQL database though, LO only seems to be able to connect the
> default schema.
>
> Sincerely,
>
> Wolfgang
     Perhaps this might help: (chapter 5.7)
http://www.postgresql.org/docs/9.3/static/ddl-schemas.html

--Dan

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted