Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
opendb [2019/04/26 13:53]
qcbs [Accessing PSQL]
opendb [2019/04/30 15:39] (current)
qcbs [Importing a table in LibreOffice Base from Calc]
Line 354: Line 354:
   * Select the entire worksheet with ctrl-a;   * Select the entire worksheet with ctrl-a;
   * Open LibreOffice Base and go to Edit...paste. Call the new table public.species_acro. Select '​Definition and data'. Select to use first line as column names. Do not create a primary key at this point.   * Open LibreOffice Base and go to Edit...paste. Call the new table public.species_acro. Select '​Definition and data'. Select to use first line as column names. Do not create a primary key at this point.
-  * Follow the wizard... Move all columns to the right to select them. Then, specify the proper data format (verify the types of attributes in the table) for the other columns. Right click on the column named 'unique_id' and select '​Primary Key'. Set the unique_id as int [int4], full_name as text [varchar] with 200 characters and species_id as text [varchar] with 30 characters. ​+  * Follow the wizard... Move all columns to the right to select them. Then, specify the proper data format (verify the types of attributes in the table) for the other columns. Right click on the column named 'species_id' and select '​Primary Key'. Set the unique_id as int [int4], full_name as text [varchar] with 200 characters and species_id as text [varchar] with 30 characters. ​