[GENERAL] Convert odb to Postgres

Hello everyone, I have an OpenOffice dabatase that I'd like to convert to Postgres. More specifically I need to replicate tables, not null constraints, primary keys, foreign keys, autonumbers and data. There's a tool that does this with Microsoft databses: http://wiki.postgresql.org/wiki/Microsof

[GENERAL] Convert odb to Postgres

Hello everyone, I have an OpenOffice dabatase that I'd like to convert to Postgres. More specifically I need to replicate tables, not null constraints, primary keys, foreign keys, autonumbers and data. There's a tool that does this with Microsoft databses: http://wiki.postgresql.org/wiki/Microsof

[GENERAL] Using record.items() method

Hello everyone, I'm trying to code a function that processes records from various tables performing the same action in each case. The functions receives as an argument a RECORD type variable and I'd like to iterate through each of its elements. According to the documentation here: http://python.p

[GENERAL] Replacing characters in a string

Hello everyone, I need to replace all occurrences of a certain character in a string. For that I'm using regexp_replace, but so far I only managed to replace the first character, here's an example: > SELECT regexp_replace('xaxx', 'x', 'e'); regexp_replace eaxx (1 row) But the

Re: [GENERAL] Replacing characters in a string

Thank you for all the answers, several ways this can be made. Luís -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general