Importing SQLite database

From: Igor Korot <ikorot01(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Importing SQLite database
Date: 2016-12-08 12:54:16
Message-ID: CA+FnnTzb8DcxXSsQhGgAtM41XPd3Ypyh90wjg6naxTg9VeTshQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, ALL,
I have a text file which I got from exporting the SQLite database.

The file contains an SQL statement which will generate the database.

Excerpt from this file:

[code]
CREATE TABLE leagues( id INTEGER AUTOINCREMENT PRIMARY KEY, name
VARCHAR(100),balance DOUBLE(10,2));
CREATE TABLE players(playerid INTEGER AUTOINCREMENT PRIMARY KEY,
player_name VARCHAR(60), player_position CHAR(1));
CREATE TABLE player_draft(id INTEGER, playerid INTEGER,
drafted_position CHAR(1), FOREIGN KEY id REFERENCE leagues(id),
FOREIGN KEY playerid REFERENCE players(playerid));
INSERT INTO leagues VALUES(1, 'Test1', 260.00);
INSERT INTO leagues VALUES(2, 'Test2', 260.00);
INSERT INTO players VALUES(1, 'Player1', 'D');
INSERT INTO players VALUES(2, ''Player2', 'F');
[/code]

My question would be:
Is there a command in Postgres which will open this file and execute all those
commands one-by-one in a transaction?
Or I will have to do a manual table creation, then split this file and
use "LOAD..."
command to load the data into the tables?

Hopefully I made myself clear.
Let me know if not and I will try to clarify further.

Thank you.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim Clarke 2016-12-08 12:59:00 Re: FreeBSD 10 => 11: Dump and reload your PostgreSQL database unless you like it broken
Previous Message Michael Paquier 2016-12-08 12:35:50 Re: pgbasebackup necessary for master slave change?