Re: [GENERAL] dump to pg

> Or spin up an AWS SQL Server instance: > > https://aws.amazon.com/windows/resources/amis/ > Thanks for the suggestion. Problem is the data is highly sensible and cannot go on the cloud or non trusted place -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] dump to pg

> If they aren't too big, you might get away by installing the express edition > of the respective DBMS, then import them using the native tools, then export > the data as CSV files. Thanks Thomas. Both are binaries. The oracle's one is a 30TB database... -- Sent via pgsql-general mailing

Re: [GENERAL] dump to pg

<vi...@xs4all.nl>: > On 2017-05-31 16:43, Nicolas Paris wrote: > >> Hi, >> >> I have dumps from oracle and microsoft sql server (no more details). >> Is it possible to load them "directly" into postgres (without >> oracle/mssql license

[GENERAL] dump to pg

Hi, I have dumps from oracle and microsoft sql server (no more details). Is it possible to load them "directly" into postgres (without oracle/mssql license)? dump -> csv -> postgtres or something ? Thanks a lot

Re: [GENERAL] Database structure advise

Le 23 avril 2017 à 12:48, Ertan Küçükoğlu écrivait : > Hello All, > > Using PostgreSQL 9.6.2 on a Windows 64bit platform. > > I am about to start a new software development dealing with warehouse > operations. Software should handle multi-company structure. There will be > single company

Re: [GENERAL] TimeScaleDB -- Open Source Time Series Database Released (www.i-programmer.info);

Le 09 avril 2017 à 05:31, Steve Petrie, P.Eng. écrivait : > Warm Greetings To pgsql-general@postgresql.org > > (I am a very newbie user of PG for a pretty trivial PHP / SQL web app. Been > lurking with great admiration for a long time, on the > pgsql-general@postgresql.org discussion list

Re: [GENERAL] Full Text Search combined with Fuzzy

Le 03 mars 2017 à 14:08, Artur Zakirov écrivait : > On 03.03.2017 15:49, Nicolas Paris wrote: > > > >Hi Oleg, > > > >Thanks. I thought pgtrgm was not able to index my long texts because of > >limitation of 8191 bytes per index row for btree. > > > >

Re: [GENERAL] Full Text Search combined with Fuzzy

Le 27 févr. 2017 à 10:32, Oleg Bartunov écrivait : > > > On Sun, Feb 26, 2017 at 3:52 PM, Nicolas Paris <nipari...@gmail.com> wrote: > > Hello, > > AFAIK there is no built-in way to combine full text search and fuzzy > matching > (https://www.p

[GENERAL] Full Text Search combined with Fuzzy

Hello, AFAIK there is no built-in way to combine full text search and fuzzy matching (https://www.postgresql.org/docs/current/static/fuzzystrmatch.html). By example, phrase searching with tipos in it. First I don't know if postgresql concurrents (lucene based...) are able to do so. Second, is

Re: [GENERAL] Fastest simple key-value store, multiple writers, like Redis?

Le 02 févr. 2017 à 20:00, Rob Nikander écrivait : > Hi, > > I'm working on a project with multiple different data storage backends. I'd > like to consolidate and use Postgres for more things. In one new situation > we're starting to use Redis, thinking it will perform better than Postgres for > a

[GENERAL] Column Tetris Automatisation

Hello, In postgresl order of columns does have an non negligeable impact on table size[1]. Table are in many cases dynamic, and new fields can appear in the database life. I suspect re-ordering columns based on types would be an automatisable task would be feaseable such: ```

Re: [GENERAL] Materialized view vs. view

Le 10/33/2017 à 21:33, David G. Johnston écrivait : >On Tue, Jan 10, 2017 at 1:01 PM, Melvin Davidson ><[1]melvin6...@gmail.com> wrote: > >Can we all agree that the "Materialized View" should be faster >​ > Yes. The OP told about a 500K rows view. Every select queries on that

Re: [GENERAL] Er Data Modeller for PostgreSQL

2016-12-29 1:03 GMT+01:00 Rich Shepard : > On Wed, 28 Dec 2016, Adrian Klaver wrote: > > An example from my machine that works: >> aklaver@tito:~/bin> java -jar schemaSpy_5.0.0.jar -t pgsql -s public -u >> postgres -db production -host localhost -dp >>

Re: [GENERAL] postgres_fdw : disable extended queries

2016-10-24 10:36 GMT+02:00 Albe Laurenz <laurenz.a...@wien.gv.at>: > Nicolas Paris wrote: > > I have a 9.6 pg instance, and I am trying to link a foreign postgresql > database that do not accept > > extended queries. (only simple queries https://www.postgresql.or

[GENERAL] postgres_fdw : disable extended queries

Hello, I have a 9.6 pg instance, and I am trying to link a foreign postgresql database that do not accept extended queries. (only simple queries https://www.postgresql.org/docs/current/static/protocol.html ) When I run a query against the foreign pg instance thought postres_fdw, it looks like it

[GENERAL] json rendering without pretty option (compact)

Hello, I want to minimize postgresql json size when I fetch them. I translate columnar table to json thought json_build_object/array or even row_to_jeon. While row_to_json do have a "pretty_bool" option, the latter do not. Each json object/array I build contains spaces. Is there a workaround ?

Re: [GENERAL] Improving speed of query

Hi, You could run 2 queries separatly and asynchrouneously 1) the limit 10 2) the count While the limit 10 query would be showned instanteneously, the web table would way for the count to build the pagination Le lun. 26 sept. 2016 à 20:59, Leonardo M. Ramé a écrit : >

[GENERAL] postgres_fdw + presto

Hello, Has anyone already tested to integrate presto (https://prestodb.io/) within postgresql thought the postgres_fdw extension ? Presto is a distributed SQL query engine able to scale horizontally on top of hadoop, cassandra or mongodb. Moreover, presto has a PostgreSQL protocol (

Re: [SPAM] [GENERAL] COPY command & binary format

washington/escience/myria/PostgresBinaryTupleWriter.java - https://github.com/bytefish/PgBulkInsert/tree/master/PgBulkInsert/src/main/de/bytefish/pgbulkinsert/pgsql/handlers Thanks, 2016-05-10 15:08 GMT+02:00 Cat <c...@zip.com.au>: > On Tue, May 10, 2016 at 03:00:55PM +0200, Nicolas Paris wro

Re: [SPAM] [GENERAL] COPY command & binary format

2016-05-10 14:47 GMT+02:00 Moreno Andreo <moreno.and...@evolu-s.it>: > Il 10/05/2016 13:38, Nicolas Paris ha scritto: > > 2016-05-10 13:04 GMT+02:00 Moreno Andreo <moreno.and...@evolu-s.it>: > >> Il 10/05/2016 12:56, Nicolas Paris ha scritto: >> >> Hell

Re: [SPAM] [GENERAL] COPY command & binary format

2016-05-10 13:04 GMT+02:00 Moreno Andreo <moreno.and...@evolu-s.it>: > Il 10/05/2016 12:56, Nicolas Paris ha scritto: > > Hello, > > What is the way to build a binary format (instead of a csv) ? Is there > specification for this file ? > http://www.postgresql.org/do

[GENERAL] COPY command & binary format

Hello, What is the way to build a binary format (instead of a csv) ? Is there specification for this file ? http://www.postgresql.org/docs/9.5/static/sql-copy.html Could I create such format from java ? I guess this would be far faster, and maybe safer than CSVs Thanks by advance,

Re: [GENERAL] postgresql & Fulltext & ranking & my own functions

Thanks Oleg, this is a good start for me 2016-05-03 15:47 GMT+02:00 Oleg Bartunov <obartu...@gmail.com>: > > > On Tue, May 3, 2016 at 3:21 PM, Nicolas Paris <nipari...@gmail.com> wrote: > >> Hello, >> >> Documentation says : ( >> http://www.postgre

[GENERAL] postgresql & Fulltext & ranking & my own functions

Hello, Documentation says : ( http://www.postgresql.org/docs/9.5/static/textsearch-controls.html#TEXTSEARCH-RANKING ) "The built-in ranking functions are only examples. You can write your own ranking functions and/or combine their results with additional factors to fit your specific needs." The

[GENERAL] Question about ranking & full text

Hi, I wonder why the third query returns 0. To me, it would return 0.1, because there is not baz in the text Thanks ! (pg 9.4) SELECT ts_rank_cd(apod.t, query,4) AS rank FROM (SELECT to_tsvector('foo baz') as t) as apod, to_tsquery('foo & baz') query WHERE query @@ apod.t; rank|

Re: [GENERAL] PostgreSQL GUI tools

I recently tried many tools, and "sql power architect" is the tool I have selected. It is compatible with liquibase, and works with postgres, mysql oracle and so on. It allows comparing structure differences between databases. Moreover it has a community free edition that covers my needs.

Re: [GENERAL] Regexp_replace question / help needed

Hi, I guess capture will help you look at http://www.postgresql.org/docs/9.0/static/functions-matching.html SELECT regexp_replace('http://test.com/test/testfile.php', '^(.*)/(.*\.php)$', E'\\1=\\2', 'g') 2015-12-09 22:58 GMT+01:00 Christopher Molnar : > Hello, > > I

Re: [GENERAL] Comparing two postgres dump files.

2015-12-03 7:12 GMT+01:00 Kaushal Shriyan : > Hi, > > Are there any scripts which will diff two pg_dump files for t1 and t2 time > period. For example pg_dump taken on t1 -> 01/11/2015 and then on t2 -> > 30/11/2015. > > backup_01112015.dump (dump taken on 01/11/2015) >

Re: [GENERAL] recursive table performance (CTE)

2015-11-11 10:44 GMT+01:00 Dusan : > Hi, > I'm using table with parent_id to themselve and WITH RECURSIVE in SELECT on > about 3thousands records. > The "tree" of data is wide (each node has more children) but not deep > (maximal depth of branch is 10 nodes). > > I'm planning to

Re: [GENERAL] PSQL Tools

Yes, moreover it provides SQL auto-completion (ctrl+space), query history, The eclipse workbench is easy, fast & reactiv. Hope I had kown DBeaver before 2015-10-19 14:49 GMT+02:00 Yves Dorfsman <y...@zioup.com>: > On 2015-10-18 16:37, Nicolas Paris wrote: > > > &g

Re: [GENERAL] PSQL Tools

2015-10-19 0:08 GMT+02:00 dinesh kumar : > On Sun, Oct 18, 2015 at 7:04 AM, wrote: > >> Hello >> >> Is anyone aware of any tools like TOAD that are available for Postgresql? >> >> > PgAdmin fits here. > > >> Regards >> >> John Wiencek >> > > > > --

Re: [GENERAL] postgresql doesn't start

​Are you using docker on centos ? I had problem with centos/docker/postgresql because container size was (maybe still is) limited to 20GB on that specific OS​. Maybe not related, but good to know 2015-10-03 0:03 GMT+02:00 John R Pierce : > On 10/2/2015 2:02 PM, Paolo De

Re: [GENERAL] Indexed views like SQL Server - NOT Materialized Views

2015-06-10 17:43 GMT+02:00 Kevin Grittner kgri...@ymail.com: inspector morse inspectormors...@gmail.com wrote: After doing that, if you add or delete a topic from the Topics Table, SQL Server automatically keeps the count updated.and it's fast because of the unique index. Doing

Re: [GENERAL] About COPY command (and probably file fdw too)

form myfile.txt into table stafflist. myfile.txt has many columns. COPY stafflist (userid, username, staffid) FROM 'myfile.txt' WITH (FORMAT text, DELIMITER E'\t', COLUMNS (1, 2, 7), ENCODING 'windows-1250') BR, Stefan Оригинално писмо От: Nicolas Paris nipari

Re: [GENERAL] About COPY command (and probably file fdw too)

2015-05-20 22:16 GMT+02:00 Stefan Stefanov stefanov...@abv.bg: Hi, I have been using COPY .. FROM a lot these days for reading in tabular data and it does a very good job. Still there is an inconvenience when a (large) text file contains more columns than the target table or the columns’

Re: [GENERAL] pgadmin3 installation on Oracle Linux 6.6 64-bit ?

Change OS, or change GUI tool https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools 2015-03-29 9:59 GMT+02:00 John R Pierce pie...@hogranch.com: On 3/29/2015 12:48 AM, Yuri Budilov wrote: Red Hat/Oracle Linux 6.x is that anything like Ford/Chevy ? Oracle Linux, while

Re: [GENERAL] Load Data with COPY

Every day I discover Postgresql's new features. Today : make women happy :) 2015-03-25 4:27 GMT+01:00 dpop...@uvic.ca: Successfully loaded two files into two different tables. Happy. :-) Diana Yes, it is a header in the .csv file. I did not know that there is such an option as

Re: [GENERAL] Change postgresql encoding

Hello, TRY in psql : update pg_database set encoding = pg_char_to_encoding('your_encoding') where datname = 'your_data_base'; Works for postgres 9.3 Nicolas PARIS 2015-02-09 9:11 GMT+01:00 Oliver ofab...@gmail.com: 2015-02-09 7:54 GMT+00:00 Oliver ofab...@gmail.com: 2015-02-08 20:50 GMT

[GENERAL] Postgresql - COPY TO - get number row inserted - from JDBC

rows inserted), I get with psql way, or with pgadmin. I have tried the int Statement.executeUpdate() method, but it returns 0 Thanks for any help ! Nicolas PARIS

Re: [GENERAL] Postgresql - COPY TO - get number row inserted - from JDBC

this is faster to read from STDIN than export the file on the remote server and then COPY FROM file exported on the remote server isn'it ? Nicolas PARIS 2015-02-07 16:40 GMT+01:00 Thomas Kellerer spam_ea...@gmx.net: Nicolas Paris wrote on 07.02.2015 15:14: Hello ! My goal is to get the result