Need help with Base

users
#21

> 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.

      Perhaps this might help: (chapter 5.7)
http://www.postgresql.org/docs/9.3/static/ddl-schemas.html

The point is not how to create a schema from within PgAdmin. I know how
to work with PostgreSQL, I've been using it for years.

The point is how to connect LO to a given, existing schema in a
PostgreSQL database.

Of course I can set a redirection to one target schema within
PostgreSQL, but that would make it impossible to connect to a different
schema within the same database.

Sincerely,

Wolfgang

#22

Hi Wolfgang,

The point is how to connect LO to a given, existing schema in a
PostgreSQL database.

I take it that schema=myschema doesn't work as a key/value pair ?

Alex

#23

I made a spreadsheet with a data-table in Excel2010 and opened it at home
with LibreOffice3.5.7.2

I don't know much about spreadsheets, but notice some differences:

- The data-table in Excel would keep the column headers visible on top when
scrolling down (without setting the header row blocked manually)
- The pivot table I made in Excel misses some data
- The data table doesn't have the coloured rows (alternating colour-no
colour) anymore

Is this expected behaviour, or should I have imported it in some special
way in LibreOffice?

Ludo

#24

Hi :slight_smile:
Sorry about my replies to this idea of using macros!

i don't use nor understand macros at all. From what people have been
saying to me off-list it sounds like they are much more efficient than i
had assumed. Plus it sounds like there is some scope for building a whole
proper app that way. It sounds well worth exploring! :slight_smile:

Anyway, many apols and regards from
Tom :slight_smile: