Calle,
Notepad++ isn't the best choice for very large files, but try EditPad Lite
instead (I'm pretty sure it's the one I used once, although it's a few year
ago), as it does some clever loading of file content. It opens even very
large files in a jiffy.
Best,
Janus
On Mon, 25 Mar 2019 at 15:57,
hi Calle:
love notepad ++ it works quite well for large files but 50gig would be
large.
if you know the pattern you are going after, I have used SED to edit or replace
the things I don’t like, especially if it its predictable.
sed is standard unix stream editor (so available on mac and
Doug,
That's neat - I wasn't aware of that. Just tried it for a 500mb dump, and
it's quick and easy - the only slightly tricker part is to edit the sql. It
worked using Notepad++ for that 500MB .sql file, but less sure if it works
if the file is 5 or 50 GB...
Anyway, nice to have it as an option.
The first post have lot's of constraint about the ID and different order
of columns, you can use copy of select's to do that stuff very easy with
psql.
Example:
server_origin, db_origin, table1 (id integer, data1 text, data2 numeric,
data3 jsonb)
server_destination, db_destination, table2(i
not sure if its been mentioned.
pg_dump -v -t (the specific table you want) which gives you the data plus the
table create plus the sql
edit sql if need be
psql -d newdatabase < theFileAbove
Doug Easterbrook
Arts Management Systems Ltd.
mailto:d...@artsman.com
http://www.artsman.com
Phon
Hi
I often use CSV as a step too:
- Dump the data you want to work on, copy/edit or whatever from db 1 in csv
- Copy the SQL for the same source table design and use it to create a
similar table in db 2 (using a different name where necessary)
- import the CSV data into that new table in db2
Then
Hi Khushboo,
And then what's the process to upload the downloaded records into the other
database?
Cheers,
Dave
On Mon, Mar 25, 2019 at 12:14 AM Khushboo Vashi <
khushboo.va...@enterprisedb.com> wrote:
>
>
> On Fri, Mar 22, 2019 at 6:06 PM Dave Caughey wrote:
>
>> Sorry, for the basic questio
