notificationcount, totaltraveldistance, start_trip, end_trip, trip_duration from public.roaster')
as roaster_test ( roaster_id serial,
roaster_date date,
pickdrop "char",
roaster_state character varying,
cab_id character varying,
shift_key integer,
roaster_creation_date date,
status integer,
notificationcount integer,
totaltraveldistance double precision,
start_trip text,
end_trip text,
trip_duration text)
Suggest me if there is any alternate way for the same.
Serial is "pseudotype" and can be used only for CREATE TABLE command. This pseudotype is translated to "int DEFAULT nextval(automatic_sequence)"
Use int instead in your case.
Regards
Pavel Stehule
Regards,
Daulat
DISCLAIMER:
This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Check all attachments for viruses before opening them. All views or opinions presented in this e-mail are those of the author and may not reflect the opinion of Cyient or those of our affiliates.