Skip to content

Category Archives: PostgreSQL

Move table in postgres to different schema

To move table to different schema in PostgreSQL use:
ALTER TABLE table_name SET SCHEMA schema_name;

Posted 26 August 2009 † AquilaX § ‡ Comments (0)

Enable PL/SQL for Database in Postgres

To enable PL/SQL in PostgreSQL use:
 
CREATE LANGUAGE ‘plpgsql’ HANDLER plpgsql_call_handler
LANCOMPILER ‘PL/pgSQL’;
 

Posted 19 November 2008 † AquilaX § ‡ Comments (0)

Alter Columns Position in Postgres

Some workarounds to alter columns position in Postgres

Posted 14 November 2008 † AquilaX § ‡ Comments (0)

SQL_CALC_FOUND_ROWS (kind of) for postgres

When I switched from MySQL to PostgreSQL, one of the things I missed the most was the ease of paging using SQL_CALC_FOUND_ROWS and SELECT FOUND_ROWS() afterwards. One of the places I use it heavily is in my Table class, which generates, sortable, filterable and paged HTML table based on an SQL Query. The tough spot [...]

Posted 06 October 2008 † AquilaX § ‡ Comments (0)