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
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
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,
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
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
On Fri, Mar 22, 2019 at 6:06 PM Dave Caughey wrote:
> Sorry, for the basic question, but I'm not sure if there are bug(s) in
> pgAdmin, or just that I'm clueless. (My money lies on the latter!)
>
> Imagine the scenario where you are adding a feature to a product that
> requires adding some new
Dave,
I think the easiest way to copy the data from one Database to another is
over foreigen data Wrappers. You could insert the configuration tables
of your production database in your dev database and then simply copy
the data with insert into (...) Select from ... Command, fast and easy
You could also use MS Access if you already have it. It can connect to
multiple databases and allow you to run an INSERT query that can pull
from one DB and save to the other.
*/Patrick Headley/*
Linx Consulting, Inc.
(303) 916-5522
phead...@linxco-inc.com
www.linxco-inc.com
On 3/22/19 8:34
Yeah, similarly, for complicated migrations that impact multiple tables
(e.g., needing to migrating FK's), I'll actually add a migration method to
my admin Java servlet, because I can then run it in a debug mode (no
commits) and have as much logging as I need to make sure that the data will
be
Dave,
When moving data *between* postgresql databases, I rely on custom python
scripts using psycopg2. A simple write loop inside a read loop and two
connections usually does the trick.
rik.
On Fri, Mar 22, 2019 at 9:59 AM Dave Caughey wrote:
> Unfortunately, using simple SQL statements
Unfortunately, using simple SQL statements isn't an option when dealing
with multiple databases (e.g., moving records from a development
environment into a production system as per my proposed use case).
Cheers,
Dave
On Fri, Mar 22, 2019 at 9:18 AM Calle Hedberg
wrote:
> Dave,
>
> You are
Dave,
If you are talking about copying records between tables in *different*
databases,
postgresql currently doesn't support this. If you are talking about
*within* the same database, 'INSERT with a SELECT CLAUSE', 'SELECT INTO',
and similar commands exist.
As far as I know;
#1 Sounds good in
Dave,
You are talking about "copying" data from one table to another table in the
same database, yes?
For that use an INSERT INTO (SELECT .FROM
sourcetable) query - it will provide most of the flexibility you need with
regard to including/excluding columns, renaming, changing column order,
Sorry, for the basic question, but I'm not sure if there are bug(s) in
pgAdmin, or just that I'm clueless. (My money lies on the latter!)
Imagine the scenario where you are adding a feature to a product that
requires adding some new rows to a configuration table, and as part of the
patch you
15 matches
Mail list logo