http://coding.sergey.me Just another WordPress weblog Tue, 02 Mar 2010 21:52:23 +0000 http://backend.userland.com/rss092 en http://coding.sergey.me/2010/03/02/cybersecurity/ Here is the way i do this - SELECT conname, t.relname AS TABLE, tf.relname AS ftable, a.attname AS field, af.attname AS ffield FROM pg_constraint c, ... http://coding.sergey.me/2010/02/05/get-list-of-all-foreign-key-constraints/ To be honest, that's not a good idea to use fork in php since it eats memory very aggressively. However, in some situations this can be really useful or can be a temporary solution. Here is an example of using php function pcntl_fork: Another useful function that can be used for downloading ... http://coding.sergey.me/2010/01/04/multithread-url-fetch-using-php/ Unfortunately i found a solution for this problem only this week, after the new postgres version 8.4 was already released. In the new version this function is already implemented along with many other functions called "window functions". In any way, for everyone that still uses Postgress version less then 8.4, here ... http://coding.sergey.me/2009/07/10/row_number-for-postgres-before-84/ "Where mysql is good, grep is good too" from russian forums... http://coding.sergey.me/2009/05/31/15/ These functions can be used to convert integer to ip and visa verse. This sometimes also called inet_itoa and inet_atoi. create or replace function inet_aton(inet) returns bigint as ' select inetmi($1,''0.0.0.0'');' language sql immutable; create or replace function inet_ntoa(int) returns inet as ' select ''0.0.0.0''::inet+$1;' language sql immutable; => select inet_ntoa(16843265); inet_itoa ----------- 1.1.2.1 (1 row) => select inet_aton('1.1.2.1'); inet_atoi ----------- 16843265 (1 row) http://coding.sergey.me/2009/03/31/inet_ntoa-and-inet_aton-functions-for-postgresql/ It took me a while to figure out how to work with remote files on server using Eclipse. It seems most of Eclipse users are developing locally and upload already tested code to the server (maybe i'am wrong). But for me it is important to work directly with remote files. While ... http://coding.sergey.me/2008/08/22/using-eclipse-for-editing-remote-files-with-sshsftp/ Get list of databases - select datname FROM pg_catalog.pg_database; This displays tables, views, indexes and sequences except postgres internal tables/views SELECT n.nspname as "Schema", c.relname as "Name", CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'i' THEN 'index' WHEN 'S' THEN 'sequence' WHEN 's' THEN 'special' END as "Type", u.usename as "Owner" FROM pg_catalog.pg_class ... http://coding.sergey.me/2008/08/21/get-list-of-databasestablesviews-in-postgresql/