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
Hi
On Fri, Mar 22, 2019 at 4:29 PM Mickael Curty wrote:
> Good afternoon,
>
> As the new pgadmin (pgadmin4) rely on web browser for the display, I
> wanted to use it like a 'phpMyAdmin', .. for postgresql, in a replacement
> of phppgadmin.
>
> But its user management make it hard (maybe I'm
Good afternoon,
As the new pgadmin (pgadmin4) rely on web browser for the display, I
wanted to use it like a 'phpMyAdmin', .. for postgresql, in a replacement
of phppgadmin.
But its user management make it hard (maybe I'm wrong about that) to plug
it to a corporate ldap authentication and
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
Hi to all,
Can someone explain me the following error ... unfortunately I am not able
to create a new server.
2019-03-22 08:43:59,581: ERROR pgadmin:'ascii' codec can't encode
character
u'\xfc' in position 33: ordinal not in range(128)
Traceback (most recent call last):
File
10 matches
Mail list logo