Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

Postgres

roger_ackroyd's profile image roger_ackroyd posted 5 years ago in General
Attempting to change the name of a table or view.
Throws and error similar to the following:-
ALTER VIEW "vw_wd_bradford_bfe" AS SELECT wd_dec_2013_gb_bfe.gid,
wd_dec_2013_gb_bfe.wd13cd,
wd_dec_2013_gb_bfe.wd13cdo,
wd_dec_2013_gb_bfe.wd13nm,
wd_dec_2013_gb_bfe.wd13nmw,
wd_dec_2013_gb_bfe.geom
FROM wd_dec_2013_gb_bfe
WHERE ((wd_dec_2013_gb_bfe.wd13cd)::text IN ( SELECT DISTINCT pcds_wd_par.wd11cd
FROM pcds_wd_par
WHERE ((pcds_wd_par.lad11nm)::text = 'Bradford'::text))); ;
/* ERROR: syntax error at or near "AS"
LINE 1: ALTER VIEW "vw_wd_bradford_bfe" AS SELECT wd_dec_2013_gb_bf...
^ */
roger_ackroyd's profile image roger_ackroyd posted 5 years ago
Postgres sorry.
ansgar's profile image ansgar posted 5 years ago
Is there some rename command in PostgreSQL, which works for tables and views?


Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.
roger_ackroyd's profile image roger_ackroyd posted 5 years ago
ALTER TABLE bd
RENAME TO bd1

ALTER VIEW vw_town
RENAME TO vw_town1

These both work in Heidi.
ansgar's profile image ansgar posted 5 years ago
Works in r4816

Please login to leave a reply, or register at first.