john.tiger wrote
> 4) su - postgres
> > password --> submitted old one, worked
> $ psql
>
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket
> "/var/run/postgresql/.s.PGSQL.5432"?
>
>
tried to follow instructions from postgresql.org/download/linux/debian
1) choice for debian versions wheezy and sid - not for testing (jessie)
2) no mention if any portions of old version should be removed
3) since I'm working on a dev machine, went ahead and removed everything
- there are no
Jayadevan M wrote:
> Jayadevan M wrote:
>> A few questions about materialized views.
>> When I refresh a materialized view, is it a DELETE/INSERT behind
>> the scenes?
With 9.3 it is closer to TRUNCATE/SELECT INTO behind the scenes.
In 9.4 (expected to be released next year) the CONCURRENTLY o
On 01/02/2014 11:19 AM, john.tiger wrote:
trying to select a row of json type returning the entire json record
table users id, jsondata
jsondata has {"username":"jdoe", }
select json_to_row from users where jsondata->"username" = "jdoe";
fails on operator -> unknown
using debian testi
I take that back, basic JSON support was introduced in PostgreSQL 9.2, and
a back-port of its functionality is also available for 9.1 here:
https://bitbucket.org/adunstan/json_91
On Thu, Jan 2, 2014 at 4:04 PM, Joshua D. Burns wrote:
> The information on apt.postgresql.org was a little outdated
The information on apt.postgresql.org was a little outdated, the last I
checked.
For information which is sure to be up to date, check out:
http://www.postgresql.org/download/linux/debian/
They describe how to add the repo to your Debian install, allowing you to
update to PostgreSQL 9.3+.
The JS
On 02/01/2014 19:19, john.tiger wrote:
> trying to select a row of json type returning the entire json record
>
> table users id, jsondata
> jsondata has {"username":"jdoe", }
>
> select json_to_row from users where jsondata->"username" = "jdoe";
>fails on operator -> unknown
>
> using
trying to select a row of json type returning the entire json record
table users id, jsondata
jsondata has {"username":"jdoe", }
select json_to_row from users where jsondata->"username" = "jdoe";
fails on operator -> unknown
using debian testing with postgresql backport ppa
psql: 9.3.2
On Thu, Jan 2, 2014 at 4:33 AM, Janek Sendrowski wrote:
> Thanks!
> It's working
you can do it without listing columns via:
select *, row_number() over(partition by c) from c;
emphasis on 'partition by c'.
merlin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
Hi All,
Below are the details:
*Connect to default database:*
*=*
bash-4.1$ ./psql -p 5432 postgres
Password:
psql.bin (9.1.7)
Type "help" for help.
postgres=#
*To list all available database:*
*=*
postgres=# \l+
On 02/01/2014 01:53, peterlen wrote:
> I am using PostgreSQL 9.1 and have boon looking for psql commands to list all
> tables in the current database as well as how to "describe" a given table.
> I have come across some info on the web (older mostly) that lists commands
> like \d, \dt, or \d+ but
Thanks!
It's working
Janek
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
12 matches
Mail list logo
