Re: [GENERAL] What's the best way in postgres to use ANY() with LIKE '%'?

Hi can see: https://stackoverflow.com/questions/4928054/postgresql-wildcard-like-for-any-of-a-list-of-words 2017-09-04 22:42 GMT-05:00 Ryan Murphy : > > I'm pretty sure it doesn't work syntactically. Don't recall the details > offhand. > > Ok, thanks! > --

[GENERAL] No funciona WITH con mas de 2 sentencias DML

Hola Lista Estaba realizando un cargue de un archivo Excel con información de clientes bancarios con tarjeta para un call center poblando un modelo maestro, detalle y tabla de llamadas telefónicas. En un principio se implemento por medio de una herramienta de ETL con los controles que ofrece la

[GENERAL] como exportar separado por comas una tabla grande

Hola Lista tengo una tabla con la siguiente estructura CREATE TABLE datos_para_proceso ( id bigint, identificador character varying, nombre character varying(255), nombreusuario text, identificacion character varying(255), tema character varying(255), notatema text, subtema

Re: [GENERAL] [pgsql-es-ayuda] como exportar separado por comas una tabla grande

Hola Alejandro Muchas gracias!! la verdad no me acordaba que el copy podía funcionar en doble via!!! 2012/10/24 Alejandro Carrillo faster...@yahoo.es http://www.postgresql.org/docs/current/static/sql-copy.html -- *De:* Hellmuth Vargas hiv...@gmail.com *Para

Re: [GENERAL] Special ORDER BY

Helo This is provided that the list is constant SELECT * FROM subcampo sc JOIN campo c ON (c.codigo = sc.campo) JOIN (values(245,1),(130,2), (240,3), (243,4), (246,5), (490,6), (630,7), (730,8), (740,9)) as d(dato,orden) on (c.etiqueta =d.dato) ORDRE BY d.orden On Tue, Jun 19, 2012

Re: [GENERAL] Is there a way to ask PostgreSQL for the name of the computer it's running on?

Hi SELECT inet_server_addr(); On Thu, Jun 14, 2012 at 4:43 PM, Guillaume Lelarge guilla...@lelarge.infowrote: On Thu, 2012-06-14 at 04:33 +, Rob Richardson wrote: My customer has 3 computers. The PostgreSQL service could be running on either of two of them. There is currently no way

[GENERAL] problem with restore: collision id`s lob

is that I have a number of postgres cluster we want to consolidate into a single cluster. Every cluster has a database with different schemas names each therefore inprinciple could create a single database where they could live all schemas and should have no problem, we generate a dump and SQL