Tags » PostgreSQL

Options for Open Source, Public Access for ATBI Data

When I worked for the NBII we used Rackspace and Amazon’s cloud service, along with MySQL for the “Species of Greatest Conservation Need” database that held a similar number of species, but no spatial data. 275 more words

Coursework

Copia de seguridad PostgreSQL (en entorno Windows)

ECHO BEGIN POSTGRESQL BACKUP %date% %time%REM **ENVIRONMENT VARIABLES

set pgdumpexe=”C::\your_path\bin\pg_dump.exe”
set dirdestino=”C:\your_path\BACKBDS\BackPostgresql”

set PGUSER= ***your_username***

set pgpassword= ***your_password***

REM **BASE DE DATOS 1
set dbname= name_of_your_database… 92 more words

PostgreSQL

Merubah type column di table postgresql

alter table mta.mmachine alter column iamper type character varying(50);

POSTGRESQL

Copying Postgresql to Another Server on Webfaction

Here is how I copied a postgresql database from one Webfaction server to another. My original thought was to do this using Fabric. But on Webfaction, they do not recommend creating or dropping databases from the command line. 178 more words

Django

How cursors degrade the performance of an SQL?

I would like to share with you all some points relating to the usage of cursors in an SQL programming code. Be it either T-SQL, PL/SQL, PL/pgSQL or any Programming Language of any RDBMS. 959 more words

Postgresql

PostgreSQL9.3をカラム指向ストレージ(cstore_fdw)に対応させる

分析向けデータベースを展開している CitusDB が PostgreSQL を列指向ストレージ対応させる foreign data wrapper(cstore_fdw) をオープンソース化したので、とりあえずインストールしてみた。

cstore_fdw の特徴

github の cstore_fdw に特徴がまとめられている。

http://citusdata.github.io/cstore_fdw/

箇条書きすると

  • Faster Analytics – Reduce analytics query disk and memory use by 10x…
  • 1,530 more words
Database

DELETE all same link but skip max(id) link

DELETE from HISQC where id in (select b.id from (select link from HISQC group by link having count(*)>1 ) as a left join (select id,link from HISQC where id not in (select max(id) from HISQC group by link having count(*)>1)) as b on a.link=b.link)

Postgresql