The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
27 views

Unable to exit a Greenplum SQL script

Is there any way in psql (Greenplum flavour) of exiting a script? I have tried with \q and \quit, e.g. \echo "Hello"; \q -- or \quit but I get: my_database> \i my_script.sql ...
1
vote
0answers
73 views

Move data from a Greenplum database to Oracle

my company is migrating its Data Warehouse from Oracle to Greenplum. The migration is gonna be progressive, that is they will migrate the ODS first and at a later stage the DDS as well. I would like ...
0
votes
0answers
42 views

How to get Greenplum table defintion?

There are already tables created in the schema but I don't know how to get the detailed information of how it was created. Like the configuration used, the orientation, etc. How do I get this ...
1
vote
0answers
114 views

How to make Greenplum 4.2.3 only scan the intended partition?

When I uses unnest() in a View, and uses that View in a select statement, Greenplum seems to fail in only searching for the intended partition and search through all the partition of the main table ...