Recent questions tagged psql

0 votes

413 views

1 answer

How do you perform the equivalent of Oracle's DESCRIBE TABLE in PostgreSQL (using the psql command)? Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

332 views

1 answer

psql - How to exclude overlapping timerange but accept common bound?

I want to prevent insertion of overlapping timerange but accept a common bound. Given the below timerange (type ... /how-to-exclude-overlapping-timerange-but-accept-common-bound...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

280 views

1 answer

psql - PostgreSQL: Drop Database but DB is still there

(This question already has answers here): question from:https://stackoverflow.com/questions/9044379/postgresql-drop-database-but-db-is-still-there...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

416 views

1 answer

psql - How do I run a sql file of inserts through docker run?

Given a file with a SQL insert: INSERT INTO countries (id, country_code, name) VALUES (1, 'AF', 'Afghanistan'), ( ... 34688465/how-do-i-run-a-sql-file-of-inserts-through-docker-run...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

326 views

1 answer

psql - Show query result column types (PostgreSQL)

Is there a way to easily get the column types of a query result? I read the psql documentation, ... /stackoverflow.com/questions/3267769/show-query-result-column-types-postgresql...

asked Oct 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

580 views

1 answer

psql - Copying postgresql local to remote database (both with password) - ERROR: option "locale" not recognized

Working with Postgres 12 / Windows 10. Trying to copy a remote database to localhost with the following ... postgresql-local-to-remote-database-both-with-password-error-option...

asked Oct 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

389 views

1 answer

psql - Copying postgresql local to remote database (both with password) - ERROR: option "locale" not recognized

Working with Postgres 12 / Windows 10. Trying to copy a remote database to localhost with the following ... postgresql-local-to-remote-database-both-with-password-error-option...

asked Oct 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags