Search found 2 matches
- Thu Sep 06, 2018 7:17 am
- Forum: Vertica SQL
- Topic: Convert PostgreSQL script to Vertica
- Replies: 2
- Views: 45646
Re: Convert PostgreSQL script to Vertica
Thanks Jim, I thought this was different forum. As I'm looking for a quick response, but you already provided me a good one. Appreciate it! Thank you. Have a great day!
- Tue Sep 04, 2018 8:13 am
- Forum: Vertica SQL
- Topic: Convert PostgreSQL script to Vertica
- Replies: 2
- Views: 45646
Convert PostgreSQL script to Vertica
Can you help me convert the below postgreSQL DDL to Vertica DDL? Having a hard time to interpret index, COLLATE pg_catalog."default", and other stuffs setting aside the basic codes (create, alter, datatypes). CREATE TABLE dev.ir_transaction_summary ( ns_period character varying(10) COLLATE pg_catalo...