If you want to export a table from the USS gateway and import into another here are some useful commands
identify the table
su - postgres
psql cloudgw
\dt (to view table list
if we decide to export radius_clients run the following
copy (select * from radius_clients) to '/tmp/radius_clients.csv' with csv header;
then view the table to get the table layout for the import command
select * from radius_clients;
you'll see this
id | name | ip_addr | secret
----+---------------+-------------+----------------------------------
once you've exported the csv from the donor gateway using WinSCP import it into the /tmp directory on the new gateway
then run this command to import the new table in the db (edit the details in brackets to layout of the csv)
COPY radius_clients(id, name, ip_addr, secret) FROM '/tmp/radius_clients.csv' WITH DELIMITER ',' CSV HEADER;
After importing a table like this remember to fix the sequences
SELECT setval('radius_clients_id_seq', COALESCE((SELECT MAX(id)+1 FROM radius_clients), 1), false);