From: | "P(dot) Jourdan" <pippo(at)videotron(dot)ca> |
---|---|
To: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: migration still a problem |
Date: | 2002-04-14 18:49:36 |
Message-ID: | 5.1.0.14.2.20020414144651.00a8fd88@pop.videotron.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | April L | 2002-04-14 19:05:40 | plpgsql and createlang? |
Previous Message | Josh Berkus | 2002-04-14 18:25:46 | Re: migration still a problem |