Различия

Здесь показаны различия между двумя версиями данной страницы.

--- postgres:dump [2021/11/17 16:53]
werwolf [С авторизацией]
+++ postgres:dump [2023/01/12 12:18] (текущий)
@@ Строка 243: / Строка 243: @@
 <code bash>
-pg_dump -U parser_wb -t sales parser_wb < /var/dump/dump2.sql
+cat /var/dump/dump.sql | grep 'INSERT INTO public.brands' > /var/dump/brands.sql
+cat /var/dump/dump.sql | grep 'INSERT INTO public.card_products' > /var/dump/card_products.sql
+cat /var/dump/dump.sql | grep 'INSERT INTO public.stocks_jsons' > /var/dump/table.sql
+cat /var/dump/dump.sql | grep 'INSERT INTO public.shippings' > /var/dump/table.sql
+cat /var/dump/dump.sql | grep 'INSERT INTO public.suppliers' > /var/dump/table.sql
+cat /var/dump/dump.sql | grep 'INSERT INTO public.servers' > /var/dump/table.sql
+cat /var/dump/dump.sql | grep 'INSERT INTO public.server_proxies' > /var/dump/table.sql
 </code>