Did you mean something like...?:
postgres=# \! echo {\menu\: { \id\: \file\ }}
/opt/pgdata/exampl.json
postgres=# select pg_read_file('/opt/pgdata/exampl.json');
pg_read_file
{menu: { id: file }}+
(1 row)
postgres=# select
Thanks Jeff! That's what I wanted to confirm, that I need to hard code /
pregenerate my dates in the query. I was mainly curious why it didn't work
with current_date, and that answers it.
And BTW, all my inserts happen on the most recent table, so my insert
trigger with a linear search is
# Introducing Open PostgreSQL Monitoring (OPM)
## Oversee and Manage Your PostgreSQL Servers
_Paris, September 8th 2014_
The OPM Development Group (see below) is proud to present the first
public release of Open PostgreSQL Monitoring, a fully open source
monitoring suite for PostgreSQL.
## Get
Hi,
I use PostrgrSQL 9.3 for couple of months now, on Windows.
I installed new Window OS, and before installing, I made tar backups of my
PostgreSQL databases.
Now I want to restore these on my new OS, but I can't find such option in
pgAdmin.
In documentation
On 09/08/2014 09:04 AM, klo uo wrote:
Hi,
I use PostrgrSQL 9.3 for couple of months now, on Windows.
I installed new Window OS, and before installing, I made tar backups of
my PostgreSQL databases.
What was the command you used?
Now I want to restore these on my new OS, but I can't find
Hi Adrian,
I used pgAdmin backup command.
However in the meantime I figured how to restore.
I first have to create database, and then use restore option which becomes
available if I right-click on a database.
On MSSQL for example, I can restore database without creating database
first, and I
Dear community,
I need a %subj% -- high performance HTTP server solution
based on asynchronous IO with ability to run PostgreSQL's
functions from HTML templates asynchronously and passing
the results to the HTTP client.
For example, consider a simple template:
html
div id=rows
${get_rows(id
On 09/08/2014 10:49 AM, klo uo wrote:
Hi Adrian,
I used pgAdmin backup command.
However in the meantime I figured how to restore.
I first have to create database, and then use restore option which
becomes available if I right-click on a database.
On MSSQL for example, I can restore database
On Sun, Sep 7, 2014 at 12:28 PM, Jeff Janes jeff.ja...@gmail.com wrote:
On Sat, Sep 6, 2014 at 12:32 AM, Abelard Hoffman abelardhoff...@gmail.com
wrote:
[snip]
I know that COPY() will escape tabs (as \t), and we can use that from psql
with the \copy command, but that does not include a
Hi Alban.
On Sun, Sep 7, 2014 at 4:18 AM, Alban Hertroys haram...@gmail.com wrote:
On 07 Sep 2014, at 10:45, Abelard Hoffman abelardhoff...@gmail.com
wrote:
For reports, everyone else mostly uses other tools? I'd like to stay
away from GUI-tools, if possible.
For reporting, usually you
On Mon, Sep 8, 2014 at 8:10 PM, Adrian Klaver wrote:
You do not have to create a database in Postgres either. There are some
system databases already created for you, template0(read only best left
alone), template1 and postgres. You can connect to one of these(best
practices, use postgres)
Is there a way for a superuser to find the last time a database had an
active user connection? (While being logged into a different database in
the same instance, of course).
The context here is looking for looking for automated integration testing
databases that have been leaked due to
John,
On Fri, Sep 5, 2014 at 2:17 PM, John R Pierce pie...@hogranch.com
wrote:
On 9/5/2014 10:31 AM, Cal Heldenbrand wrote:
Number of child tables: 1581
that's an insane number of children. We try and limit it to 50 or so
child tables, for instance, 6 months retention by week, of data
On 9/8/2014 1:40 PM, Andreas Brandl wrote:
can you explain that further? In the end, that argument sounds like it would always
be more efficient to use a single table and its index instead, rather than
partitioning it (log(N) c*log(N/c) for any c 1, if I'm not totally lost
today).
it
I've imported a csv export of an MS SQL Server log file into a staging table on
my local install of Postgresql (9.3/UTF8 encoding) for analysis.
The staging table definition is:
CREATE TABLE sql_log_import
(
id serial NOT NULL,
ts text, -- will convert to ts when merging into
On Mon, Sep 8, 2014 at 12:59 PM, Dmitriy Igrishin dmit...@gmail.com wrote:
Dear community,
I need a %subj% -- high performance HTTP server solution
based on asynchronous IO with ability to run PostgreSQL's
functions from HTML templates asynchronously and passing
the results to the HTTP
I suspect your data is not what you think it is.
What do you see when you do
SELECT ts FROM from sql_log_import LIMIT 3;
On Mon, Sep 8, 2014 at 4:52 PM, Lou Oquin loq...@nammotalley.com wrote:
I’ve imported a csv export of an MS SQL Server log file into a staging
table on my local install
Lou Oquin loq...@nammotalley.com writes:
Ive imported a csv export of an MS SQL Server log file into a staging table
on my local install of Postgresql (9.3/UTF8 encoding) for analysis.
The staging table definition is:
CREATE TABLE sql_log_import
(
id serial NOT NULL,
ts text, --
I think this is the first time I've ever reported a PG crash, which is notable
since I've been using PG for over 10 years. ;)
Using the 9.4 Beta RPMs on CentOS 6.X/64, we're experiencing a reproducible
crash when running a query with a left outer join, partially collapsed.
TRAP:
On Mon, Sep 8, 2014 at 1:40 PM, Andreas Brandl m...@3.141592654.de wrote:
John,
On Fri, Sep 5, 2014 at 2:17 PM, John R Pierce pie...@hogranch.com
wrote:
On 9/5/2014 10:31 AM, Cal Heldenbrand wrote:
Number of child tables: 1581
that's an insane number of children. We try and limit it
On Sun, Sep 7, 2014 at 5:17 PM, Melvin Davidson melvin6...@gmail.com
wrote:
the output I'd prefer is:
id fld_1
1 test\tvalue
2 test\tvalue
3 test\tvalue
*Does this work for you?copy (SELECT id, replace(fld_1, '', '\t') FROM
tsv_test) to stdout with csv header delimiter '
On 09/08/2014 01:52 PM, Lou Oquin wrote:
I’ve imported a csv export of an MS SQL Server log file into a staging
table on my local install of Postgresql (9.3/UTF8 encoding) for analysis.
The staging table definition is:
CREATE TABLE sql_log_import
(
id serial NOT NULL,
ts text, -- will
The data is
ts
08/06/2014 03:08:58
08/06/2014 03:08:58
08/06/2014 03:08:58
Hmmm, this works for me:
CREATE TABLE sql_log_import
(
id serial NOT NULL,
ts text, -- will convert to ts when merging into sql_server_logs
CONSTRAINT sql_log_import_pk PRIMARY KEY (id)
)
WITH ( OIDS=FALSE );
On 09/08/2014 04:06 PM, Lou Oquin wrote:
I'm executing the query in pgAdmin3, in a SQL query window. The results are
coming from the history tab of the output pane.
Alright. I was trying to clear up confusion on my end, because the log
entries you show are coming from SQL Server.
Do you
On 09/08/2014 01:52 PM, Lou Oquin wrote:
I’ve imported a csv export of an MS SQL Server log file into a staging
table on my local install of Postgresql (9.3/UTF8 encoding) for analysis.
select to_timestamp(ts, 'MM/DD/ hh24:mi:ss')::timestamp with time
zone as tStamp
from sql_log_import
li...@benjamindsmith.com writes:
Using the 9.4 Beta RPMs on CentOS 6.X/64, we're experiencing a reproducible
crash when running a query with a left outer join, partially collapsed.
The test case crashes as described for me. Will take a look tomorrow.
Thanks for the report!
On Tue, Sep 9, 2014 at 6:36 AM, li...@benjamindsmith.com wrote:
What other information should I provide? We have the machine available if
necessary.
This can be reproduced without especially LEFT OUTER JOIN, and system
crashes as long as index path is taken in planner, and that WHERE
clause
27 matches
Mail list logo