337
edits
Changes
Jump to navigation
Jump to search
→SQL Commands
EXPLAIN ANALYZE SELECT * FROM x;
===Python Functions ===
[[Installing python in a database]] - if Python is not already installed
Source: https://www.postgresql.org/docs/9.4/static/plpython-funcs.html
To get into database via terminal:
1) ssh researcher@128.42.44.181
2) cd \folder_name
3) psql database_name
Creating Functions:
CREATE FUNCTION pymax (a integer, b integer)
RETURNS integer
AS $$
if a > b:
return a
return b
$$ LANGUAGE plpythonu;
[[admin_classification::IT Build| ]]
