Install unrar in Centos

Code:

wget http://dag.wieers.com/packages/unrar/unrar-3.6.2-1.el4.rf.i386.rpm


and to extract a file user you type

unrar e -kb rarfile.rar

Install unrar in Centos

Code:

wget http://dag.wieers.com/packages/unrar/unrar-3.6.2-1.el4.rf.i386.rpm


and to extract a file user you type

unrar e -kb rarfile.rar

postgreSQL: Multiple schemas in one database

How to query a table from other schema than "pulic" schema?

If a database contains more than one named schemas, you can query use schema_name.table_name to query the content of the table.

select * from myschema.mytable;

create table myschema.mytable(

......

);

You alswaysa can simplify this by changing the search path.

SHOW search_path;

will show the current search path. The follwoing command will add the schema myachema into the search_path. so next time you do not need to use myschema.mytable to query data.

SET search_path TO myschema,public;

postgreSQL: Multiple schemas in one database

How to query a table from other schema than "pulic" schema?

If a database contains more than one named schemas, you can query use schema_name.table_name to query the content of the table.

select * from myschema.mytable;

create table myschema.mytable(

......

);

You alswaysa can simplify this by changing the search path.

SHOW search_path;

will show the current search path. The follwoing command will add the schema myachema into the search_path. so next time you do not need to use myschema.mytable to query data.

SET search_path TO myschema,public;

How to use drupal variable in sql query in view

The drupal website path is http://domain/v1/v2/v3

and the varials in the path is arg(0)=v1, arg(1)=v2 and arg(2)=v3

So in your sql command in view, you can use like this:

$argument= arg(1);

$view--> build_info['query']="select * from table_name where name='$argument'";

Note:

1. there is no need to add schema name in front of the table name even the schema is not public

2. give alias name to each table and field

SELECT feature.feature_id AS feature_id,
    feature.uniquename as feature_uniquename
      FROM feature feature
      LEFT JOIN featureloc fl ON feature.feature_id = fl.feature_id
      LEFT JOIN feature srcf ON fl.srcfeature_id = srcf.feature_id
      WHERE srcf.name = '$argument'"

How to use drupal variable in sql query in view

The drupal website path is http://domain/v1/v2/v3

and the varials in the path is arg(0)=v1, arg(1)=v2 and arg(2)=v3

So in your sql command in view, you can use like this:

$argument= arg(1);

$view--> build_info['query']="select * from table_name where name='$argument'";

Note:

1. there is no need to add schema name in front of the table name even the schema is not public

2. give alias name to each table and field

SELECT feature.feature_id AS feature_id,
    feature.uniquename as feature_uniquename
      FROM feature feature
      LEFT JOIN featureloc fl ON feature.feature_id = fl.feature_id
      LEFT JOIN feature srcf ON fl.srcfeature_id = srcf.feature_id
      WHERE srcf.name = '$argument'"

Chado and postgreSQL: ERROR: function create_point(integer, integer) does not exist

I have two chado databases installed locally. One is individually installed the other one is installed insideTripal.

While I am running queries with the Chado database which is installed inside Tripal, it gives me some error message sometimes,

ERROR:  function create_point(integer, integer) does not exist

To solve this problem I have to create the functions by myself. it seems that the funsctin were not preloaded into the Chado schema insides tripal.

Query I issued on this database:

SELECT feature.uniquename FROM chado.feature LEFT JOIN chado.featureloc fl ON (chado.feature.feature_id = fl.feature_id)LEFT JOIN chado.feature srcf ON (fl.srcfeature_id = srcf.feature_id) WHERE srcf.name = 'IncAC_plasmid_SH163';

 

links: http://generic-model-organism-system-database.450254.n5.nabble.com/Error-at-the-time-of-chado-database-import-on-frange-featuregoup-foreign-keys-td460184.html