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 12/10/2016 11:32 AM, Igor Korot 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 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 i
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 number, its a true/fals
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.
https://www.postgresql.org/docs/current/static/datatype-boolean.ht
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 integer, playerid integer, ishitter
>> char, age
> 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 decimal, currvalue decimal,
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 decimal, draft boolean,
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 in
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 domain socket "/var/pgsql_s
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 [po
r 2016 16:09
>> To: Igor Korot
>> Cc: pgsql-general@postgresql.org
>> 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
>
Hello
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Adrian Klaver
> Sent: Donnerstag, 8. Dezember 2016 16:09
> To: Igor Korot
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENE
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 u
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 will generate the 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 SQLite database.
>>>
>>> The file contains an SQL st
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.
>
>
> Is there a CREATE 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 th
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] http://www.omnid
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 player
19 matches
Mail list logo
