Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ## This is how I set up the database (after apt-get installs)
- su - postgres
- psql
- \password postgres
- mypsswd
- mypsswd
- \q
- exit
- ## Then I import database settings to postgres: this is ODKAggregate - https://opendatakit.org/use/aggregate/tomcat-install/
- su - postgres
- psql
- \cd /home/edison
- \i create_db_and_user.sql
- \q
- exit
- ## Now I've created some records, and try to access them.
- \c odk-mm
- ou are now connected to database "odk-mm" as user "postgres".
- odk-mm=# \d
- List of relations
- Schema | Name | Type | Owner
- --------+------------+-------+----------
- public | c3po_alive | table | odk_user
- (1 row)
- dk-mm=# \dt *.*
- List of relations
- Schema | Name | Type | Owner
- --------------------+-------------------------------------------------------+-------+----------
- information_schema | sql_features | table | postgres
- information_schema | sql_implementation_info | table | postgres
- information_schema | sql_languages | table | postgres
- information_schema | sql_packages | table | postgres
- information_schema | sql_parts | table | postgres
- information_schema | sql_sizing | table | postgres
- information_schema | sql_sizing_profiles | table | postgres
- odk-mm-schema | 01_RESCUED_PEOPLE_DATA_FORM_0_1_CORE | table | odk_user
- odk-mm-schema | 01_RESCUED_PEOPLE_DATA_FORM_0_1_DETAILS_VULNERABILITY | table | odk_user
- odk-mm-schema | 02_RESCUED_VESSEL_DETAILS_0_1_CORE | table | odk_user
- odk-mm-schema | _backend_actions | table | odk_user
- odk-mm-schema | _filter_group | table | odk_user
- odk-mm-schema | _form_data_model | table | odk_user
- odk-mm-schema | _form_info | table | odk_user
- odk-mm-schema | _form_info_fileset | table | odk_user
- odk-mm-schema | _form_info_manifest_bin | table | odk_user
- odk-mm-schema | _form_info_manifest_blb | table | odk_user
- odk-mm-schema | _form_info_manifest_ref | table | odk_user
- odk-mm-schema | _form_info_submission_association | table | odk_user
- odk-mm-schema | _form_info_xform_bin | table | odk_user
- odk-mm-schema | _form_info_manifest_blb | table | odk_user
- odk-mm-schema | _form_info_manifest_ref | table | odk_user
- odk-mm-schema | _form_info_submission_association | table | odk_user
- odk-mm-schema | _form_info_xform_bin | table | odk_user
- odk-mm-schema | _form_info_xform_ref | table | odk_user
- odk-mm-schema | _form_service_cursor_2 | table | odk_user
- odk-mm-schema | _granted_authority_hierarchy | table | odk_user
- odk-mm-schema | _misc_tasks | table | odk_user
- odk-mm-schema | _persistent_result_file_bin | table | odk_user
- odk-mm-schema | _persistent_result_file_blb | table | odk_user
- odk-mm-schema | _persistent_result_file_ref | table | odk_user
- odk-mm-schema | _persistent_results | table | odk_user
- odk-mm-schema | _registered_users | table | odk_user
- odk-mm-schema | _security_revisions | table | odk_user
- odk-mm-schema | _server_preferences_properties | table | odk_user
- odk-mm-schema | _task_lock | table | odk_user
- odk-mm-schema | _user_granted_authority | table | odk_user
- pg_catalog | pg_aggregate | table | postgres
- pg_catalog | pg_am | table | postgres
- pg_catalog | pg_amop | table | postgres
- pg_catalog | pg_amproc | table | postgres
- pg_catalog | pg_attrdef | table | postgres
- pg_catalog | pg_attribute | table | postgres
- pg_catalog | pg_auth_members | table | postgres
- pg_catalog | pg_authid | table | postgres
- pg_catalog | pg_cast | table | postgres
- pg_catalog | pg_collation | table | postgres
- pg_catalog | pg_constraint | table | postgres
- pg_catalog | pg_conversion | table | postgres
- pg_catalog | pg_database | table | postgres
- pg_catalog | pg_db_role_setting | table | postgres
- pg_catalog | pg_default_acl | table | postgres
- pg_catalog | pg_depend | table | postgres
- pg_catalog | pg_description | table | postgres
- pg_catalog | pg_enum | table | postgres
- pg_catalog | pg_event_trigger | table | postgres
- pg_catalog | pg_extension | table | postgres
- pg_catalog | pg_foreign_data_wrapper | table | postgres
- pg_catalog | pg_foreign_server | table | postgres
- pg_catalog | pg_foreign_table | table | postgres
- pg_catalog | pg_index | table | postgres
- pg_catalog | pg_inherits | table | postgres
- pg_catalog | pg_language | table | postgres
- pg_catalog | pg_largeobject | table | postgres
- pg_catalog | pg_largeobject_metadata | table | postgres
- pg_catalog | pg_namespace | table | postgres
- pg_catalog | pg_opclass | table | postgres
- pg_catalog | pg_operator | table | postgres
- pg_catalog | pg_pltemplate | table | postgres
- pg_catalog | pg_policy | table | postgres
- pg_catalog | pg_proc | table | postgres
- pg_catalog | pg_range | table | postgres
- pg_catalog | pg_replication_origin | table | postgres
- pg_catalog | pg_rewrite | table | postgres
- pg_catalog | pg_seclabel | table | postgres
- pg_catalog | pg_shdepend | table | postgres
- pg_catalog | pg_shdescription | table | postgres
- pg_catalog | pg_shseclabel | table | postgres
- pg_catalog | pg_statistic | table | postgres
- pg_catalog | pg_tablespace | table | postgres
- pg_catalog | pg_transform | table | postgres
- pg_catalog | pg_trigger | table | postgres
- pg_catalog | pg_ts_config | table | postgres
- pg_catalog | pg_ts_config_map | table | postgres
- pg_catalog | pg_ts_dict | table | postgres
- pg_catalog | pg_ts_parser | table | postgres
- pg_catalog | pg_ts_template | table | postgres
- pg_catalog | pg_type | table | postgres
- pg_catalog | pg_user_mapping | table | postgres
- public | c3po_alive | table | odk_user
- (89 rows)
- ## I'm not sure where to go from here..
- odk-mm=# SELECT * from 01_RESCUED_PEOPLE_DATA_FORM_0_1_CORE;
- ERROR: syntax error at or near "01"
- LINE 1: SELECT * from 01_RESCUED_PEOPLE_DATA_FORM_0_1_CORE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement