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 pg_read_file('/opt/
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 ordere
# 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 (http://www.postgresql.org/docs/9.3/
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 such
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 guess
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:
${get_rows(id := :id)}
Th
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 with
On Sun, Sep 7, 2014 at 12:28 PM, Jeff Janes wrote:
> On Sat, Sep 6, 2014 at 12:32 AM, Abelard Hoffman > 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 header row of the
>> column names.
>>
>
> W
Hi Alban.
On Sun, Sep 7, 2014 at 4:18 AM, Alban Hertroys wrote:
> On 07 Sep 2014, at 10:45, Abelard Hoffman
> wrote:
>
> > For reports, everyone else mostly uses other tools? I'd like to stay
> away from GUI-tools, if possible.
>
> For reporting, usually you use the data in the database directl
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 postgre
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 bugs/crash
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,
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 ind
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 sql_server_logs
On Mon, Sep 8, 2014 at 12:59 PM, Dmitriy Igrishin 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 client.
> For exa
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 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/UTF
Lou Oquin 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, -- will conve
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: FailedAsserti
On Mon, Sep 8, 2014 at 1:40 PM, Andreas Brandl 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 to
On Sun, Sep 7, 2014 at 5:17 PM, Melvin Davidson
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=FALS
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 ha
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, 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 uses a given combination o
Thank you for reply.
>concat() invokes datatype output functions, which are not necessarily
>immutable. An easy example is that timestamptz_out's results depend
>on the TimeZone setting.
I understood.
-
Regards,
Vinayak,
--
View this message in context:
http://postgresql.1045698.n5.na
28 matches
Mail list logo
