Help with Postgres script, missing extension citext
$10-30 CAD
Ολοκληρώθηκε
Αναρτήθηκε περίπου 4 χρόνια πριν
$10-30 CAD
Πληρωμή κατά την παράδοση
I need help figuring out a Postgres script. I created the following script to reproduce the error I'm having on secure server database. The following script will not run because it cannot find extension "citext". I've added the extension but it seems to always add to database public instead of dbo.
I will on occasion have other small jobs that I will need Postgres help with in the future.
CREATE DATABASE test;
SET search_path TO test;
CREATE SCHEMA dbo;
CREATE EXTENSION citext WITH SCHEMA dbo; -- error: extension "citext" already exists
-- This is the important part. I cannot change the create table SQL and it must retain dbo.citext.
CREATE TABLE dbo."Books" ( -- error: type "[login to view URL]" does not exist
"Name" [login to view URL],
"Description" text
);
Hi There, I am here 24/7, I'm a Data Expert(Big data/ Data Science/Web Scraping/Web automation)
check my Linkedin profile: [login to view URL]
I've reviewed your requirements, I am very interested in your post project. I'm excited about feeling that I would be able to satisfy your requirements in this job. Please leave a message on my chat so we can discuss the project. We can negotiate on the budget.
Thank.
$30 CAD σε 3 ημέρες
5,0 (1 αξιολόγηση)
0,7
0,7
2 freelancers δίνουν μια μέση προσφορά $30 CAD για αυτή τη δουλειά