Tag : postgres

Title User Language Tags Description Date
Convert OID to Bytea arunpjohny SQL

Convert an oid value into a bytea value.

 January 16, 2012
show most expensive queries in postgres log limepix Bash

maybe you must replace "Dauer" with the correct spelling in your logging language (i´ve done this on a german system). also make sure, that the duration (the value in ms) column is the 5th one in your log file.

 December 30, 2011
Postgres: Schema resotre arunpjohny SQL

Restore a postgres schema backup file.

 August 26, 2011
Postgres Schema Backup arunpjohny SQL

Take backup of a schema with large objects

 August 26, 2011
Postgres: alter not null constraint arunpjohny SQL July 6, 2011
Postgres: alter default arunpjohny SQL July 6, 2011
Postgres - Install and Create databases and users for Fedora 14 ragnarokkrr Bash July 1, 2011
Scheduling automatic backup of postgres database in windows arunpjohny DOS Batch May 24, 2011
Postgres: How to insert oid value using JDBC API arunpjohny Java May 21, 2011
Postgres: How to read oid value using JDBC API arunpjohny Java May 21, 2011
Postgresql Alter table command to add not null contraint arunpjohny Java November 26, 2010
Primitive PostgreSQL console shell ccpizza python

Primitive shell for running PostgreSQL quieries from console. Make sure you set the right connection settings in the script.

All queries are executed in autocommit mode.

Example command line usage:

pg.py select * from mytable where oidh=1

The script recognizes a number of magic keywords:

pg.py show databases
pg.py show schemas
pg.py describe <table_name>
November 25, 2010
Create Postgres DB/user insanedreamer SQL November 17, 2010
Create database in PostgreSQL axolx SQL August 22, 2010
Export/import subset of data from table in Postgres jturmel Bash August 6, 2010