I am new to postgresql. I installed a software from git
When i check the tables for this, i see
indico=> \dt
List of relations
Schema | Name | Type | Owner
--------+----------------------+-------+--------
indico | designer_image_files | table | indico
indico | designer_templates | table | indico
indico | ip_network_groups | table | indico
indico | ip_networks | table | indico
indico | news | table | indico
indico | reference_types | table | indico
indico | settings | table | indico
indico | settings_principals | table | indico
public | alembic_version | table | indico
(9 rows)
indico=>
Look like this do not list all tables in the database as i can see any of the table listed have user info.
When i run
indico=> SELECT table_schema,table_name FROM information_schema.tables ORDER BY table_schema,table_name;
table_schema | table_name
-----------------------+---------------------------------------
attachments | attachment_principals
attachments | attachments
attachments | files
attachments | folder_principals
attachments | folders
attachments | legacy_attachment_id_map
attachments | legacy_folder_id_map
categories | categories
categories | legacy_id_map
categories | principals
categories | settings
event_abstracts | abstract_comments
event_abstracts | abstract_field_values
event_abstracts | abstract_person_links
event_abstracts | abstract_review_questions
event_abstracts | abstract_review_ratings
event_abstracts | abstract_reviews
event_abstracts | abstracts
event_abstracts | email_logs
event_abstracts | email_templates
event_abstracts | files
event_abstracts | proposed_for_tracks
event_abstracts | reviewed_for_tracks
event_abstracts | submitted_for_tracks
event_paper_reviewing | competences
event_paper_reviewing | content_reviewers
event_paper_reviewing | files
event_paper_reviewing | judges
event_paper_reviewing | layout_reviewers
event_paper_reviewing | review_comments
event_paper_reviewing | review_questions
event_paper_reviewing | review_ratings
event_paper_reviewing | reviews
event_paper_reviewing | revisions
event_paper_reviewing | templates
event_registration | form_field_data
event_registration | form_items
event_registration | forms
event_registration | invitations
event_registration | legacy_registration_map
event_registration | registration_data
event_registration | registrations
events | agreements
events | breaks
events | contribution_fields
events | contribution_field_values
events | contribution_person_links
events | contribution_principals
events | contribution_references
events | contributions
events | contribution_types
events | event_person_links
events | event_references
events | events
events | image_files
events | legacy_contribution_id_map
events | legacy_id_map
events | legacy_image_id_map
events | legacy_page_id_map
events | legacy_session_block_id_map
events | legacy_session_id_map
events | legacy_subcontribution_id_map
events | logs
events | menu_entries
events | note_revisions
events | notes
events | pages
events | payment_transactions
events | persons
events | principals
events | reminders
events | requests
events | series
events | session_block_person_links
events | session_blocks
events | session_principals
events | sessions
events | settings
events | settings_principals
events | static_list_links
events | static_sites
events | subcontribution_person_links
events | subcontribution_references
events | subcontributions
events | timetable_entries
events | track_abstract_reviewers
events | track_conveners
events | tracks
events | vc_room_events
events | vc_rooms
event_surveys | answers
event_surveys | items
event_surveys | submissions
event_surveys | surveys
indico | designer_image_files
indico | designer_templates
indico | ip_network_groups
indico | ip_networks
indico | news
indico | reference_types
indico | settings
indico | settings_principals
information_schema | administrable_role_authorizations
information_schema | applicable_roles
information_schema | attributes
information_schema | character_sets
information_schema | check_constraint_routine_usage
information_schema | check_constraints
information_schema | collation_character_set_applicability
information_schema | collations
information_schema | column_domain_usage
information_schema | column_options
information_schema | column_privileges
information_schema | columns
information_schema | column_udt_usage
information_schema | constraint_column_usage
information_schema | constraint_table_usage
information_schema | data_type_privileges
information_schema | domain_constraints
information_schema | domains
information_schema | domain_udt_usage
information_schema | element_types
information_schema | enabled_roles
information_schema | foreign_data_wrapper_options
information_schema | foreign_data_wrappers
information_schema | foreign_server_options
information_schema | foreign_servers
information_schema | foreign_table_options
information_schema | foreign_tables
information_schema | information_schema_catalog_name
information_schema | key_column_usage
information_schema | parameters
information_schema | referential_constraints
information_schema | role_column_grants
information_schema | role_routine_grants
information_schema | role_table_grants
information_schema | role_udt_grants
information_schema | role_usage_grants
information_schema | routine_privileges
information_schema | routines
information_schema | schemata
information_schema | sequences
information_schema | sql_features
information_schema | sql_implementation_info
information_schema | sql_languages
information_schema | sql_packages
information_schema | sql_sizing
information_schema | sql_sizing_profiles
information_schema | table_constraints
information_schema | table_privileges
information_schema | tables
information_schema | triggered_update_columns
information_schema | triggers
information_schema | udt_privileges
information_schema | usage_privileges
information_schema | user_defined_types
information_schema | user_mapping_options
information_schema | user_mappings
information_schema | view_column_usage
information_schema | view_routine_usage
information_schema | views
information_schema | view_table_usage
oauth | applications
oauth | tokens
pg_catalog | pg_aggregate
pg_catalog | pg_am
pg_catalog | pg_amop
pg_catalog | pg_amproc
pg_catalog | pg_attrdef
pg_catalog | pg_attribute
pg_catalog | pg_auth_members
pg_catalog | pg_available_extensions
pg_catalog | pg_available_extension_versions
pg_catalog | pg_cast
pg_catalog | pg_class
pg_catalog | pg_collation
pg_catalog | pg_constraint
pg_catalog | pg_conversion
pg_catalog | pg_cursors
pg_catalog | pg_database
pg_catalog | pg_db_role_setting
pg_catalog | pg_default_acl
pg_catalog | pg_depend
pg_catalog | pg_description
pg_catalog | pg_enum
pg_catalog | pg_event_trigger
pg_catalog | pg_extension
pg_catalog | pg_foreign_data_wrapper
pg_catalog | pg_foreign_server
pg_catalog | pg_foreign_table
pg_catalog | pg_group
pg_catalog | pg_index
pg_catalog | pg_indexes
pg_catalog | pg_inherits
pg_catalog | pg_init_privs
pg_catalog | pg_language
pg_catalog | pg_largeobject_metadata
pg_catalog | pg_locks
pg_catalog | pg_matviews
pg_catalog | pg_namespace
pg_catalog | pg_opclass
pg_catalog | pg_operator
pg_catalog | pg_opfamily
pg_catalog | pg_pltemplate
pg_catalog | pg_policies
pg_catalog | pg_policy
pg_catalog | pg_prepared_statements
pg_catalog | pg_prepared_xacts
pg_catalog | pg_proc
pg_catalog | pg_range
pg_catalog | pg_replication_origin
pg_catalog | pg_replication_slots
pg_catalog | pg_rewrite
pg_catalog | pg_roles
pg_catalog | pg_rules
pg_catalog | pg_seclabel
pg_catalog | pg_seclabels
pg_catalog | pg_settings
pg_catalog | pg_shdepend
pg_catalog | pg_shdescription
pg_catalog | pg_shseclabel
pg_catalog | pg_stat_activity
pg_catalog | pg_stat_all_indexes
pg_catalog | pg_stat_all_tables
pg_catalog | pg_stat_archiver
pg_catalog | pg_stat_bgwriter
pg_catalog | pg_stat_database
pg_catalog | pg_stat_database_conflicts
pg_catalog | pg_statio_all_indexes
pg_catalog | pg_statio_all_sequences
pg_catalog | pg_statio_all_tables
pg_catalog | pg_statio_sys_indexes
pg_catalog | pg_statio_sys_sequences
pg_catalog | pg_statio_sys_tables
pg_catalog | pg_statio_user_indexes
pg_catalog | pg_statio_user_sequences
pg_catalog | pg_statio_user_tables
pg_catalog | pg_stat_progress_vacuum
pg_catalog | pg_stat_replication
pg_catalog | pg_stats
pg_catalog | pg_stat_ssl
pg_catalog | pg_stat_sys_indexes
pg_catalog | pg_stat_sys_tables
pg_catalog | pg_stat_user_functions
pg_catalog | pg_stat_user_indexes
pg_catalog | pg_stat_user_tables
pg_catalog | pg_stat_wal_receiver
pg_catalog | pg_stat_xact_all_tables
pg_catalog | pg_stat_xact_sys_tables
pg_catalog | pg_stat_xact_user_functions
pg_catalog | pg_stat_xact_user_tables
pg_catalog | pg_tables
pg_catalog | pg_tablespace
pg_catalog | pg_timezone_abbrevs
pg_catalog | pg_timezone_names
pg_catalog | pg_transform
pg_catalog | pg_trigger
pg_catalog | pg_ts_config
pg_catalog | pg_ts_config_map
pg_catalog | pg_ts_dict
pg_catalog | pg_ts_parser
pg_catalog | pg_ts_template
pg_catalog | pg_type
pg_catalog | pg_user
pg_catalog | pg_user_mappings
pg_catalog | pg_views
public | alembic_version
roombooking | aspects
roombooking | blocked_rooms
roombooking | blocking_principals
roombooking | blockings
roombooking | equipment_types
roombooking | holidays
roombooking | locations
roombooking | photos
roombooking | reservation_edit_logs
roombooking | reservation_equipment
roombooking | reservation_occurrences
roombooking | reservations
roombooking | room_attributes
roombooking | room_attribute_values
roombooking | room_bookable_hours
roombooking | room_equipment
roombooking | room_nonbookable_periods
roombooking | rooms
users | affiliations
users | api_keys
users | emails
users | favorite_categories
users | favorite_users
users | group_members
users | groups
users | identities
users | registration_requests
users | settings
users | suggested_categories
users | users
(297 rows)
indico=>
I get 297 items.
When i try to see records from table users, i get following error
indico=> select * from users;
ERROR: relation "users" does not exist
LINE 1: select * from users;
^
indico=>
How i list users in the table users ?