Re: [GENERAL] Importing SQLite database

Thank you Adrian. That was it. Now I can continue testing. On Sat, Dec 10, 2016 at 11:26 PM, Adrian Klaver wrote: > On 12/10/2016 06:56 PM, Igor Korot wrote: >> >> Hi, >> >> On Sat, Dec 10, 2016 at 2:50 PM, John R Pierce >> wrote: >>> >>> On

Re: [GENERAL] Importing SQLite database

On 12/10/2016 06:56 PM, Igor Korot wrote: Hi, On Sat, Dec 10, 2016 at 2:50 PM, John R Pierce wrote: On 12/10/2016 11:32 AM, Igor Korot wrote: Looking athttps://www.postgresql.org/docs/9.5/static/datatype-numeric.html, I don't see a 'boolean' as supported data type.

Re: [GENERAL] Importing SQLite database

Hi, On Sat, Dec 10, 2016 at 2:50 PM, John R Pierce wrote: > On 12/10/2016 11:32 AM, Igor Korot wrote: >> >> Looking >> athttps://www.postgresql.org/docs/9.5/static/datatype-numeric.html, >> I don't see a 'boolean' as supported data type. > > > thats because boolean isn't a

Re: [GENERAL] Importing SQLite database

On 12/10/2016 11:32 AM, Igor Korot wrote: Looking athttps://www.postgresql.org/docs/9.5/static/datatype-numeric.html, I don't see a 'boolean' as supported data type. thats because boolean isn't a number, its a true/false value.

Re: [GENERAL] Importing SQLite database

2016-12-10 20:43 GMT+01:00 Pavel Stehule : > > > 2016-12-10 20:32 GMT+01:00 Igor Korot : > >> Hi, guys, >> I'm working thru my script and I hit a following issue: >> >> In the script I have a following command: >> >> CREATE TABLE playersinleague(id

Re: [GENERAL] Importing SQLite database

> On Dec 10, 2016, at 11:32 AM, Igor Korot wrote: > > Hi, guys, > I'm working thru my script and I hit a following issue: > > In the script I have a following command: > > CREATE TABLE playersinleague(id integer, playerid integer, ishitter > char, age integer, value

Re: [GENERAL] Importing SQLite database

2016-12-10 20:32 GMT+01:00 Igor Korot : > Hi, guys, > I'm working thru my script and I hit a following issue: > > In the script I have a following command: > > CREATE TABLE playersinleague(id integer, playerid integer, ishitter > char, age integer, value decimal, currvalue

Re: [GENERAL] Importing SQLite database

Hi, guys, I'm working thru my script and I hit a following issue: In the script I have a following command: CREATE TABLE playersinleague(id integer, playerid integer, ishitter char, age integer, value decimal, currvalue decimal, draft boolean, isnew char(1), current_rank integer, original_rank

Re: [GENERAL] Importing SQLite database

Adrian Klaver writes: > On 12/08/2016 04:47 PM, Igor Korot wrote: >> Igors-MacBook-Air:dbhandler igorkorot$ psql -U postgres -d postgres >> psql: could not connect to server: No such file or directory >> Is the server running locally and accepting >> connections on Unix

Re: [GENERAL] Importing SQLite database

On 12/08/2016 04:47 PM, Igor Korot wrote: Hi, guys, This is the result of running "SQL shell": [code] Last login: Thu Dec 8 19:46:41 on ttys001 Igors-MacBook-Air:~ igorkorot$ /Library/PostgreSQL/9.1/scripts/runpsql.sh; exit Server [localhost]: Database [postgres]: Port [5432]: Username

Re: [GENERAL] Importing SQLite database

; Sent: Donnerstag, 8. Dezember 2016 16:09 >> To: Igor Korot <ikoro...@gmail.com> >> Cc: pgsql-general@postgresql.org >> Subject: Re: [GENERAL] Importing SQLite database >> >> On 12/08/2016 06:54 AM, Igor Korot wrote: >> > Adrian, >> >

Re: [GENERAL] Importing SQLite database

> Subject: Re: [GENERAL] Importing SQLite database > > On 12/08/2016 06:54 AM, Igor Korot wrote: > > Adrian, > > > > On Thu, Dec 8, 2016 at 9:47 AM, Adrian Klaver <adrian.kla...@aklaver.com> > > wrote: > >> On 12/08/2016 04:54 AM, Igor Korot wrote:

Re: [GENERAL] Importing SQLite database

On 12/08/2016 07:02 AM, Igor Korot wrote: Adrian, Anything else you see? Does Postgres uses single quotes for literal values or double quotes? Single: https://www.postgresql.org/docs/9.5/static/sql-syntax-lexical.html I'm talking about INSERT INTO... VALUES(); statements. SQLite does

Re: [GENERAL] Importing SQLite database

On 12/08/2016 06:54 AM, Igor Korot wrote: Adrian, On Thu, Dec 8, 2016 at 9:47 AM, Adrian Klaver wrote: On 12/08/2016 04:54 AM, Igor Korot wrote: Hi, ALL, I have a text file which I got from exporting the SQLite database. The file contains an SQL statement which

Re: [GENERAL] Importing SQLite database

Adrian, On Thu, Dec 8, 2016 at 9:54 AM, Igor Korot wrote: > Adrian, > > On Thu, Dec 8, 2016 at 9:47 AM, Adrian Klaver > wrote: >> On 12/08/2016 04:54 AM, Igor Korot wrote: >>> >>> Hi, ALL, >>> I have a text file which I got from exporting the

Re: [GENERAL] Importing SQLite database

Adrian, On Thu, Dec 8, 2016 at 9:47 AM, Adrian Klaver wrote: > On 12/08/2016 04:54 AM, Igor Korot wrote: >> >> 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. > >

Re: [GENERAL] Importing SQLite database

On 12/08/2016 04:54 AM, Igor Korot wrote: 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. Is there a CREATE DATABASE statement in the file you are referencing? Otherwise you will have to create

Re: [GENERAL] Importing SQLite database

OmniDB [1] is able to convert databases from one RDBMS to another. I suggest you perform a conversion from your SQLite file to a PostgreSQL database. This page [2] can help you on how to add connections to OmniDB and this other page [3] explains how to use the convert feature. [1]

[GENERAL] Importing SQLite database

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