Re: [GENERAL] Selectively Importing Data

2015-10-31 Thread Raymond O'Donnell
On 31/10/2015 00:24, David Blomstrom wrote: > First consider the following table: > > create table taxon ( > taxonid serial, > descr text > ); > > As I understand it, "serial" means that column will automatically > populate with a numerical key. > > If I want to fill the field 'descr' with

Re: [GENERAL] Selectively Importing Data

2015-10-31 Thread Charles Clavadetscher
om>; pgsql-general@postgresql.org > Subject: Re: [GENERAL] Selectively Importing Data > > On 31/10/2015 00:24, David Blomstrom wrote: > > First consider the following table: > > > > create table taxon ( > > taxonid serial, > > descr text > > ); > &g

Re: [GENERAL] Selectively Importing Data

2015-10-31 Thread David Blomstrom
postgresql.org [mailto: > pgsql-general-ow...@postgresql.org] On Behalf Of Raymond O'Donnell > > Sent: Samstag, 31. Oktober 2015 12:42 > > To: David Blomstrom <david.blomst...@gmail.com>; > pgsql-general@postgresql.org > > Subject: Re: [GENERAL] Selectively Importing Data &g

[GENERAL] Selectively Importing Data

2015-10-30 Thread David Blomstrom
First consider the following table: create table taxon ( taxonid serial, descr text ); As I understand it, "serial" means that column will automatically populate with a numerical key. If I want to fill the field 'descr' with a list of scientific names stored in a spreadsheet, then how would

Re: [GENERAL] Selectively Importing Data

2015-10-30 Thread Andy Colson
On 10/30/2015 07:24 PM, David Blomstrom wrote: First consider the following table: create table taxon ( taxonid serial, descr text ); As I understand it, "serial" means that column will automatically populate with a numerical key. If I want to fill the field 'descr' with a list of