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
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'"
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'"
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
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
Slow deleting behavior in Windows Xp
I have windows up machine at work. Everything runs fine except I noticed it is hard for me to delete files from the hard disk no matter how big the file. Sometimes, the operating system is paused waiting for the delete task to complete. I have checked the hard disk problem and defrag the hard disk. But they are not helping.
After searching online, I found one solution: "disable the 1394 Net Adapter". At beginning, I do not believe it will help. But it works!
After searching online, I found one solution: "disable the 1394 Net Adapter". At beginning, I do not believe it will help. But it works!
Slow deleting behavior in Windows Xp
I have windows up machine at work. Everything runs fine except I noticed it is hard for me to delete files from the hard disk no matter how big the file. Sometimes, the operating system is paused waiting for the delete task to complete. I have checked the hard disk problem and defrag the hard disk. But they are not helping.
After searching online, I found one solution: "disable the 1394 Net Adapter". At beginning, I do not believe it will help. But it works!
After searching online, I found one solution: "disable the 1394 Net Adapter". At beginning, I do not believe it will help. But it works!
Clear Firfox Address Bar History
To definitely clear your firefox address bar histories, you can follow these steps:
1. In the Location bar, enter about:config
2. Search for the preference browser.urlbar.maxRichResults.
3. Double-click the browser.urlbar.maxRichResults preference and enter a value of -1.
4. Close Firefox.
5. Start Firefox again.
Does this work for you?
1. In the Location bar, enter about:config
2. Search for the preference browser.urlbar.maxRichResults.
3. Double-click the browser.urlbar.maxRichResults preference and enter a value of -1.
4. Close Firefox.
5. Start Firefox again.
Does this work for you?
Clear Firfox Address Bar History
To definitely clear your firefox address bar histories, you can follow these steps:
1. In the Location bar, enter about:config
2. Search for the preference browser.urlbar.maxRichResults.
3. Double-click the browser.urlbar.maxRichResults preference and enter a value of -1.
4. Close Firefox.
5. Start Firefox again.
Does this work for you?
1. In the Location bar, enter about:config
2. Search for the preference browser.urlbar.maxRichResults.
3. Double-click the browser.urlbar.maxRichResults preference and enter a value of -1.
4. Close Firefox.
5. Start Firefox again.
Does this work for you?
Subscribe to:
Posts (Atom)