Re: migration still a problem - Mailing list pgsql-novice

From P. Jourdan
Subject Re: migration still a problem
Date
Msg-id 5.1.0.14.2.20020414144651.00a8fd88@pop.videotron.ca
Whole thread Raw
In response to Re: migration still a problem  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-novice
At 11:25 AM 4/14/2002 -0700, you wrote:

>Next step:  First, copy the original file in case your text editor
>causes problems.  Second, copy the, say, first 30 lines of the file and
>post them with your next reply.  That should be enough to tell if it's
>a pg_dump or pg_dumpall file.
>
>-Josh

Here are the first 25 lines:

Username: Password:
\connect - med
CREATE SEQUENCE "category_category_id_seq" start 60 increment 1 maxvalue
2147483647 minvalue 1  cache 1 ;
SELECT nextval ('"category_category_id_seq"');
CREATE SEQUENCE "contact_contact_id_seq" start 576 increment 1 maxvalue
2147483647 minvalue 1  cache 1 ;
SELECT nextval ('"contact_contact_id_seq"');
CREATE SEQUENCE "currency_rates_currency_rate" start 21 increment 1
maxvalue 2147483647 minvalue 1  cache 1 ;
SELECT nextval ('"currency_rates_currency_rate"');
CREATE SEQUENCE "customer_customer_id_seq" start 49 increment 1 maxvalue
2147483647 minvalue 1  cache 1 ;
SELECT nextval ('"customer_customer_id_seq"');
CREATE SEQUENCE "flow_flow_id_seq" start 5 increment 1 maxvalue 2147483647
minvalue 1  cache 1 ;
SELECT nextval ('"flow_flow_id_seq"');
CREATE SEQUENCE "news_news_id_seq" start 1 increment 1 maxvalue 2147483647
minvalue 1  cache 1 ;
SELECT nextval ('"news_news_id_seq"');
CREATE SEQUENCE "order_status_order_status_id" start 7 increment 1 maxvalue
2147483647 minvalue 1  cache 1 ;
SELECT nextval ('"order_status_order_status_id"');
CREATE SEQUENCE "order_types_order_type_id_se" start 3 increment 1 maxvalue
2147483647 minvalue 1  cache 1 ;
SELECT nextval ('"order_types_order_type_id_se"');
CREATE SEQUENCE "orders_order_id_seq" start 4 increment 1 maxvalue
2147483647 minvalue 1  cache 1 ;
SELECT nextval ('"orders_order_id_seq"');
CREATE SEQUENCE "pages_pages_id_seq" start 26 increment 1 maxvalue
2147483647 minvalue 1  cache 1 ;
SELECT nextval ('"pages_pages_id_seq"');
CREATE SEQUENCE "price_types_price_type_id_se" start 5 increment 1 maxvalue
2147483647 minvalue 1  cache 1 ;
SELECT nextval ('"price_types_price_type_id_se"');

Philip Jourdan


pgsql-novice by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: migration still a problem
Next
From: April L
Date:
Subject: plpgsql and createlang?