Excel CANCAT date and time to POSTGRESQL timestamp
Formula example:
=TEXT(E3;"yyyy-mm-dd")&" "&TEXT(G3;"hh:mm:ss")
Postgres select columns names without default value
PostgreSQL select column names where there is no default value : SELECT column_name, column_default FROM information_schema.columns WHERE (table_schema, table_name) = ('public', 'test') AND column_default IS NULL ORDER BY ordinal_position;
Comments
Post a Comment