Hi,
I am trying to follow what has been mentioned below **Setting Up Postgres**
(https://www.digitalocean.com/community/tutorials/how-to-setup-ruby-on-rails-with-postgres).
But no luck!
[shreyas@myapp(add_postgres_addapter)]$ su - postgres
Password:
su: Sorry
[shreyas@myapp (add_postgres_addapt
On Mon, Mar 30, 2015 at 5:09 PM, Arup Rakshit
wrote:
> Hi,
>
> I am trying to follow what has been mentioned below **Setting Up
> Postgres** (
> https://www.digitalocean.com/community/tutorials/how-to-setup-ruby-on-rails-with-postgres
> ).
>
> But no luck!
>
> [shreyas@myapp(add_postgres_addapter
Hi all,
Have you ever experienced how to populate fields from a MS Office Word
document with a PostgreSQL data available either in a table or view?
I haven’t seen anything on the web; only possible with MS products, VS or
Access.
Thank you for your input
Two options that I know of:
1) Use Java and the Apache POI project
2) Write a file containing the data in some other format like HTML then
open that with Word.
Tim Clarke
On 30/03/15 09:20, avpro avpro wrote:
>
> Hi all,
>
> Have you ever experienced how to populate fields from a MS Office Word
>
I sample data as below-
{
"glossary": {
"title": "example glossary",
"GlossDiv": {
"title": "S",
"GlossList": {
"GlossEntry": {
"ID": "SGML",
"SortAs": "SGML
On 28 March 2015 at 02:14, Yuri Budilov wrote:
> I am new to PostgreSQL and Linux (coming across from Microsoft SQL Server).
>
> I installed PostgreSQL 9.4 on Oracle Linux 6.6 and its working ok (psql,
> etc).
> Now I try to install pgadmin3 on the same OS.
>
> I am having problems installing pda
On Mon, Mar 30, 2015 at 6:54 PM, Kavi wrote:
>
> I sample data as below-
>
>
> {
> "glossary": {
> "title": "example glossary",
> "GlossDiv": {
> "title": "S",
> "GlossList": {
> "GlossEntry": {
> "ID
On Mon, Mar 30, 2015 at 7:11 PM, Michael Paquier
wrote:
>
>
>
> On Mon, Mar 30, 2015 at 6:54 PM, Kavi wrote:
>
>>
>> I sample data as below-
>>
>>
>> {
>> "glossary": {
>> "title": "example glossary",
>> "GlossDiv": {
>> "title": "S",
>>
Hi,
I want to ask a question about json index.
Can I make a index on a field of a json column?
e.g, for table 'json_tab' you given, can I run something like "create index
'json_index' on json_tab::key"?
On Mon, Mar 30, 2015 at 6:11 PM, Michael Paquier
wrote:
>
>
> On Mon, Mar 30, 2015 at 6:54 PM
If you have windows then yes something like vba to pull data into MS Office
Word .. search google for 'ms word odbc connection' a postgres mailing list is
not the right place to do this search
If you are on *nix don't have/want windows & office products but want to
generate/write to a MS Offic
Hi,
> I want to ask a question about json index.
> Can I make a index on a field of a json column?
> e.g, for table 'json_tab' you given, can I run something like "create
> index 'json_index' on json_tab::key"?
>
Yes.
Here it is an example:
http://stackoverflow.com/questions/17807030/how-to-crea
I have a multi-table join which will return 1 row per "interface" and I
would like to aggregate the interfaces as a nested section on the resulting
JSON output. Could someone help me to figure out how to accomplish that?
Example:
SELECT row_to_json(row) AS json
> FROM (
> SELECT
> c.s
On Mon, Mar 30, 2015 at 3:09 AM, Arup Rakshit
wrote:
> Hi,
>
> I am trying to follow what has been mentioned below **Setting Up Postgres**
> (https://www.digitalocean.com/community/tutorials/how-to-setup-ruby-on-rails-with-postgres).
>
> But no luck!
>
> [shreyas@myapp(add_postgres_addapter)]$ su
On Mon, 30 Mar 2015 10:20:15 +0200
avpro avpro wrote:
> Have you ever experienced how to populate fields from a MS Office Word
> document with a PostgreSQL data available either in a table or view?
>
> I haven’t seen anything on the web; only possible with MS products, VS or
> Access.
Hi,
I us
Hello,
I need your help speeding up the procedure I will explain below. I am
looking for improvements to my method or different approaches/ideas to
would help in this matter.
I have a set of DBF files that I load into my database using a plpython
function and a call to ogr2ogr (http://www.gdal.or
Hi all,
I am interesting in understanding the extensibility features available in
PostgreSQL. For instance what it takes to define a new operator or a new
index and in particular what goes into the query optimizer in that case.
Please kindly point me to some useful resources on this.
Thanks and
On 03/30/2015 01:09 AM, Arup Rakshit wrote:
Hi,
I am trying to follow what has been mentioned below **Setting Up Postgres**
(https://www.digitalocean.com/community/tutorials/how-to-setup-ruby-on-rails-with-postgres).
But no luck!
[shreyas@myapp(add_postgres_addapter)]$ su - postgres
Password:
On 03/30/2015 06:20 AM, Danushka Menikkumbura wrote:
Hi all,
I am interesting in understanding the extensibility features available
in PostgreSQL. For instance what it takes to define a new operator or a
new index and in particular what goes into the query optimizer in that case.
Please kindly
Postgres documentation is really excellent.
http://www.postgresql.org/docs/9.1/static/extend.html should get you
started.
On Mon, Mar 30, 2015 at 2:20 PM, Danushka Menikkumbura <
danushka.menikkumb...@gmail.com> wrote:
> Hi all,
>
> I am interesting in understanding the extensibility features a
On 03/30/2015 06:04 AM, Guillaume Drolet wrote:
Hello,
I need your help speeding up the procedure I will explain below. I am
looking for improvements to my method or different approaches/ideas to
would help in this matter.
I have a set of DBF files that I load into my database using a plpython
To prevent multiple foreign table scans during queries, I would like to be
able to create an FDW against a VIEW in a foreign MySQL database. Is this
possible?
Thanks in advance!
Deven
Nevermind, it works exactly as I would have expected and it is the exact
speed improvement I needed!
Deven
On Mon, Mar 30, 2015 at 10:12 AM, Deven Phillips
wrote:
> To prevent multiple foreign table scans during queries, I would like to be
> able to create an FDW against a VIEW in a foreign MyS
Hello,
I am developing a C++ extension (most of the code is C++) for postgres that
links dynamically with liblwgeom, without linking to postgis. I call
liblwgeom functions that serialize/deserialize LWGEOM* (and similar
structures) that don't need a backend like GEOS.
I wonder how is the memory f
On 3/30/2015 1:20 AM, avpro avpro wrote:
Have you ever experienced how to populate fields from a MS Office Word
document with a PostgreSQL data available either in a table or view?
I haven’t seen anything on the web; only possible with MS products, VS
or Access.
Thank you for your input
Igor,
Your supposition is is all correct (you might want to ask your
questions on postgis-devel, where the developer density is higher).
lwalloc by default is just a facade over malloc, for standalone use.
But, when used in PostGIS, it it backed by palloc, which is in turn
the memory manager provid
Il 30.03.2015 15:01, Vincent Veyron ha scritto:
Hi,
I use Perl for this. The process is :
-unzip the .docx document, and look for /word/document.xml in the resulting
directory
-substitute field names with their values in this file (I don't use MS Word
'fields', though, just placeholders that
On 3/30/2015 10:18 AM, John R Pierce wrote:
On 3/30/2015 1:20 AM, avpro avpro wrote:
Have you ever experienced how to populate fields from a MS Office Word
document with a PostgreSQL data available either in a table or view?
I haven’t seen anything on the web; only possible with MS products, V
On Mon, 30 Mar 2015 17:37:28 +0200
Vincenzo Campanella wrote:
Stirling Newberry wrote:
>post the code
Here you go :
http://pastebin.com/eVXZiFws
This is a mod_perl module used in the HeaderParser phase of the Apache request
cycle; it first grabs the sql associated with the model, and passes
Hi all,
I have a query which selects several rows of data, and contained in one
of those rows is some aggregated JSON data. I am using row_to_json() to
make the whole output JSON and I am providing "true" for pretty formatting
of the JSON. The problem that I am seeing is that they nested JSON
Here's an example of the JSON output I am getting:
{"customer_code":"abcd",
"vdc":1241,
"vmid":114778,
"uuid":"421ea391-b292-ca2e-9a3a-6da3037748c8",
"name":"vmname",
"os":"Red Hat Enterprise Linux 6 (64-bit)",
"service_type":"CU",
"template_name":"",
"self":"
https://mysite.mydomain.tld/v
On Tue, Mar 24, 2015 at 12:49 PM, Bankim Bhavsar
wrote:
> Hello postgres experts,
>
> We are running a test that periodically abruptly kills postgres
> process(equivalent to kill -9) and restarts it.
> After running this test for 24 hrs or so, we see duplicate primary key
> entries in postgres tab
On Mon, Mar 30, 2015 at 6:27 AM, Deven Phillips
wrote:
> I have a multi-table join which will return 1 row per "interface" and I
> would like to aggregate the interfaces as a nested section on the resulting
> JSON output. Could someone help me to figure out how to accomplish that?
>
> Example:
>
>
On Mon, Mar 30, 2015 at 12:54 PM, Deven Phillips
wrote:
> Hi all,
>
> I have a query which selects several rows of data, and contained in one
> of those rows is some aggregated JSON data. I am using row_to_json() to make
> the whole output JSON and I am providing "true" for pretty formatting o
Hi , all the installation of the BDR according to the documentation:
https://wiki.postgresql.org/wiki/BDR_Packages
I have set the following parameters:
max_replication_slots = 3
max_wal_senders = 4
wal_level = 'logical'
track_commit_timestamp = on
shared_preload_libraries = 'bdr'
m
want to include html text from newsletters into postgres - then retrieve
have seen posts saying this is really difficult (?) and others just
sugesting pg_escape_string and pg entities -
tried to put into text field but it seems stripped out
does anyone have a good suggestion
--
Sent via pgsql
On Mon, Mar 30, 2015 at 1:06 PM, john.tiger
wrote:
> want to include html text from newsletters into postgres - then retrieve
>
> have seen posts saying this is really difficult (?) and others just
> sugesting pg_escape_string and pg entities -
> tried to put into text field but it seems stripped
On 03/30/2015 10:54 AM, Deven Phillips wrote:
Hi all,
I have a query which selects several rows of data, and contained in
one of those rows is some aggregated JSON data. I am using row_to_json()
to make the whole output JSON and I am providing "true" for pretty
formatting of the JSON. The p
Thanks Adrian,
In option 2, when you say "this is automated in an external Python script",
do you mean that you use something like psycopg2 to perform the queries the
database (e.g. for comparing data in the holding table with the older
table)?
Thanks.
2015-03-30 9:53 GMT-04:00 Adrian Klaver :
thank you all for your responses.
I think to easiest option for me would be to use the ODBC connection. Now
my problem is where to start with the VBA code; but that's for another list.
cheers
On 30 March 2015 at 19:51, Vincent Veyron wrote:
> On Mon, 30 Mar 2015 17:37:28 +0200
> Vincenzo Campan
On 03/30/2015 01:43 PM, Guillaume Drolet wrote:
Thanks Adrian,
In option 2, when you say "this is automated in an external Python
script", do you mean that you use something like psycopg2 to perform the
queries the database (e.g. for comparing data in the holding table with
the older table)?
Y
Sorry, typo!!
CREATE OR REPLACE FUNCTION get_vm_with_interfaces(vm_id BIGINT) RETURNS
jsonb AS $$
DECLARE
res jsonb;
BEGIN
SELECT array_to_json(array_agg(row_to_json(i, true)), true)
FROM (
SELECT DISTINCT * FROM virtual_interfaces WHERE vmid=vm_id) i
INTO res;
RETURN r
I'm using PostgreSQL 9.4.1 on Ubuntu 14.10.
The function does the following:
DROP FUNCTION get_vm_with_interfaces(vm_id BIGINT);
CREATE OR REPLACE FUNCTION get_virtual_interfaces(vm_id BIGINT) RETURNS
jsonb AS $$
DECLARE
res jsonb;
BEGIN
SELECT array_to_json(array_agg(row_to_json(i, true)),
On Mon, Mar 30, 2015 at 4:22 PM, Deven Phillips
wrote:
> I'm using PostgreSQL 9.4.1 on Ubuntu 14.10.
>
> The function does the following:
>
> DROP FUNCTION get_vm_with_interfaces(vm_id BIGINT);
>
> CREATE OR REPLACE FUNCTION get_virtual_interfaces(vm_id BIGINT) RETURNS
> jsonb AS $$
> DECLARE
>
On Mon, Mar 30, 2015 at 3:30 PM, Adrian Klaver
wrote:
> On 03/30/2015 10:54 AM, Deven Phillips wrote:
>>
>> Hi all,
>>
>> I have a query which selects several rows of data, and contained in
>> one of those rows is some aggregated JSON data. I am using row_to_json()
>> to make the whole output
On Mon, Mar 30, 2015 at 1:51 PM, avpro avpro wrote:
> thank you all for your responses.
>
> I think to easiest option for me would be to use the ODBC connection. Now
> my problem is where to start with the VBA code; but that's for another list.
> cheers
>
> On 30 March 2015 at 19:51, Vincent Veyr
Open Office etc can populate fields via JDBC from any database including
PostgreSQL.
Cheers,
Stephen
On 30/03/15 19:52, Tim Clarke wrote:
Two options that I know of:
1) Use Java and the Apache POI project
2) Write a file containing the data in some other format like HTML then
open that with Wo
Hi
On 15/03/31 4:59, negrus wrote:
> Hi , all the installation of the BDR according to the documentation:
>
> https://wiki.postgresql.org/wiki/BDR_Packages
>
> I have set the following parameters:
>
> max_replication_slots = 3
> max_wal_senders = 4
> wal_level = 'logical'
> track_comm
I have already attempted a similar approach and I could not find a way to
pass the outer value of the VM ID to the inner SELECT. For example:
SELECT
row.snt_code AS "snt_code",
row.vdc AS "vdc",
row.uuid AS "uuid",
row_to_json(row, true)::json AS "json"
FROM (
SELECT
vm
48 matches
Mail list logo
