All kinds of database records

All kinds of database records

Elasticsearch Database:

First, ES introduction

Second, ES common operation

ES database for test environment: 172.16.50.24:9200/_plugin/head/(log in to the database host to see if head and SQL plug-ins are installed if you cannot log in)

Create a new index

Create a new Index table

Greenplum Database:

First, GP introduction
Second, GP common commands

Login database: psql-d chinacloud (database name)-H 172.16.50.22 (host address)-P 5432 (port)-U postgres (username)

View Database: \l

Switch database: \c database name; (equivalent to use databases)

View the table for the current database: \dt

View table structure: \d table name; (equivalent to the SQL DESC tablename)

Add a table: CREATE TABLE TableName (id,srting);

Delete a table: drop table tablename;

All kinds of database records