tencent cloud

All product documents
Tencent Cloud WeData
DocumentationTencent Cloud WeDataOperation GuideData DevelopmentTask DevelopmentTask Node TypeTDSQL PostgreSQL
TDSQL PostgreSQL
Download PDF
Last updated: 2024-11-01 16:26:14
TDSQL PostgreSQL
Last updated: 2024-11-01 16:26:14
Download PDF
Note:
This project needs to bind the data source of TDSQL for PostgreSQL.

Sample code

-- Create schema
create schema if not exists wedata_demo_schema ;

-- Create a table
CREATE TABLE wedata_demo_schema.user_info (
  id SERIAL PRIMARY KEY,
  name VARCHAR(255) NOT NULL
);

-- View tables in the corresponding schema
SELECT table_name 
FROM information_schema.tables 
WHERE table_schema = 'wedata_demo_schema';

-- Insert data
INSERT INTO wedata_demo_schema.user_info (name) VALUES ('Alice'), ('Bob');

-- View data
select * from  wedata_demo_schema.user_info;

Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon