if you are running on Linux you may be interested in what worked for me: sudo apt-get install postgresql sudo apt-get install libpq-dev Then gem install pg then bundle install src: http://wikimatze.de/installing-postgresql-gem-under-ubuntu-and-mac
It’s easy, just look the example. –my databases postgres=# \l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges ———–+———-+———-+———+——-+————————— francs | postgres | UTF8 | C | C | =Tc/postgres + | | | | | postgres=CTc/postgres + | | | | | francs=C*T*c*/postgres + | | | … Read more
ALTER TABLE yksus1 SET SCHEMA firma1; More details in the manual: http://www.postgresql.org/docs/current/static/sql-altertable.html Associated indexes, constraints, and sequences owned by table columns are moved as well. Not sure about the trigger function though, but there is an equivalent ALTER FUNCTION .. SET SCHEMA … as well.
Based on the comments and answers here, and some rudimentary research, I have the following summary to offer for comments from the Postgres-erati. Will really appreciate your input. There are three ways to restrict entries in a Postgres database table column. Consider a table to store “colors” where you want only ‘red’, ‘green’, or ‘blue’ … Read more
Can be done without conversion to/from int (but to/from timestamp instead) SELECT date_trunc(‘day’, dd):: date FROM generate_series ( ‘2007-02-01’::timestamp , ‘2008-04-01’::timestamp , ‘1 day’::interval) dd ;
You can also do select table_name from information_schema.columns where column_name=”your_column_name”
ALTER TABLE person ALTER COLUMN phone DROP NOT NULL; More details in the manual: http://www.postgresql.org/docs/9.1/static/sql-altertable.html
In all schemas: => \dt *.* In a particular schema: => \dt public.* It is possible to use regular expressions with some restrictions \dt (public|s).(s|t) List of relations Schema | Name | Type | Owner ——–+——+——-+——- public | s | table | cpn public | t | table | cpn s | t | table … Read more
With postgresql-9.3 one can do this; SELECT g.id, array_remove(array_agg(CASE WHEN g.canonical=”Y” THEN g.users ELSE NULL END), NULL) canonical_users, array_remove(array_agg(CASE WHEN g.canonical=”N” THEN g.users ELSE NULL END), NULL) non_canonical_users FROM groups g GROUP BY g.id; Update: with postgresql-9.4; SELECT g.id, array_agg(g.users) FILTER (WHERE g.canonical=”Y”) canonical_users, array_agg(g.users) FILTER (WHERE g.canonical=”N”) non_canonical_users FROM groups g GROUP BY g.id; … Read more
I think you’re looking for SELECT select_expressions INTO: select test_table.name into name from test_table where id = x; That will pull the name from test_table where id is your function’s argument and leave it in the name variable. Don’t leave out the table name prefix on test_table.name or you’ll get complaints about an ambiguous reference.