Copy table behaviour

Answered

Hi there I just noticed that when I use Datagrip to copy a table from one Postgres db to another, it converted a column of type jsonb to a column of type text.  Is this intended behaviour and can it not be flagged to the user?

1 comment
Comment actions Permalink

For now, if one imports table between two similar databases it goes through the same engine that used to import between different databases.
As a temporary workaround, you can create table in another database using DDL and import data to it either via drag-n-drop or via import feature (F5).

 

0

Please sign in to leave a comment.