[SQL] problem with spanish characters

Hello everybody,   I’m not sure if this is a bug on the upper/lower command or anywhere else.   This is the problem:     I have a DB that uses ‘UNICODE’ encoding. PostgreSQL version is 7.4.2.     I have a field that holds characters, including characters like ‘Ñ’ (lowercase versio

[SQL] EXPORT / IMPORT

Hello,   Is there a simple way to generate an export / import script in PostgreSQL (i.e. a script that contains INSERT statements for every row in a table) ???   COPY is NOT a good option (personal opinion).   I’m using pgAdmin3 but it does not offer this (quite disappointing, may I s

[SQL] COUNT on a DISTINCT query

Hello everybody,   I’m a newbie to PostgreSQL.   I have the following query:   SELECT DISTINCT (at.*) FROM AGRUPACION_TERRITORIAL at, LINK_AGRUP_TE_MUNICIPIO link, MUNICIPIO m, PROVINCIA p, CCAA c WHERE at.agru_id_agrupacion_t = link.agmu_id_agrupacion_t AND link.agmu