uploading sql ddl file to postgresql database -

-

i relatively new working on databases. created sql file , want upload ddl (data definition language) file postgresql server. server runs on ubuntu 12.04. 

create database *;  --create tables create table user(     user_id      varchar(36)    not null,     username     varchar(36)    not null,     user_type    varchar(36)    not null,     name         varchar(36)    not null,     email        varchar(36)    not null,     picture      varchar(36)    not null );  create table product(     product_id           varchar(36)    not null,     product_name         varchar(36)    not null,     product_type         varchar(36)    not null,     product_price        varchar(36)    not null,     product_available    varchar(36)    not null );  create table transaction(     transaction_id    varchar(36)    not null,     user_id           varchar(36)    not null,     product_id        varchar(36)    not null );  create table inventory(     product_id           varchar(36)    not null,     product_name         varchar(36)    not null,     product_available    varchar(36)    not null );

i not asking how fix file. asking how can upload file postgresql server. advance help.

running script

to run ddl in form of sql script, should use psql, same command use connect server interactively.

psql -h the.server.hostname -f my_script.sql the_database

i recommend using on_error_stop=1 , -1, runs ddl in single transaction , aborts on error.

psql -v on_error_stop=1 -1 -h the.server.hostname -f my_script.sql the_database

creating db

you can't create database start creating tables. must connect other db run create database , if you've connected db, that's tables created.

you can put psql command \c databasename in after create database, it'll create db switch it. it's bad idea: if create fails, script merrily keep on creating tables in wrong db unless use on_error_stop. can't use -1 (run in single transaction) if create , switch new db.

instead, manually create database first, or separate script. way can run ddl script sensibly.

the ddl

your schema needs work.

no primary keys.

no foreign keys.

use of varchar(36) everywhere, it's wildly inappropriate names , email addresses. use unbounded text type, or varchar no length (they're same thing in postgresql anyway) if don't have need constrain length of field specific reason.


Comments

Post a Comment

Popular posts from this blog

Change the color of an oval at click in Java AWT -

-
i have draw ovals in java, , @ click change color. beginning tried change color after 20 ms, doesn't work. my code is: public class mycomponentnew extends frame { public graphics2d g2d; public mycomponentnew(string title) { super(title); setsize(400, 550); } @override public void paint(graphics g) { this.g2d = (graphics2d) g; this.g2d.setcolor(color.red); this.g2d.filloval(10, 55, 50, 100); } public void changecolor () { this.g2d.setcolor(color.blue); this.g2d.filloval(10, 55, 50, 100); } } and in class main method have: mycomponentnew m; m = new mycomponentnew("fereastra cu baloane"); m.setvisible(true); m.addwindowlistener(new windowadapter() { @override public void windowclosing(windowevent we) { system.exit(0); } }); try { thread.sleep(20); } catch(interruptedexception e) {} m.changecolor(); the color of oval remains red. ...
Read more

c# - Unity IoC Lifetime per HttpRequest for UserStore -

-
i'm trying clean default implementation of accountcontroller.cs comes out of box in new mvc5/owin security implementation. have modified constructor this: private usermanager<applicationuser> usermanager; public accountcontroller(usermanager<applicationuser> usermanager) { this.usermanager = usermanager; } also, have created lifetime manager unity looks this: public class httpcontextlifetimemanager<t> : lifetimemanager, idisposable { private httpcontextbase _context = null; public httpcontextlifetimemanager() { _context = new httpcontextwrapper(httpcontext.current); } public httpcontextlifetimemanager(httpcontextbase context) { if (context == null) throw new argumentnullexception("context"); _context = context; } public void dispose() { this.removevalue(); } public override object get...
Read more

I am trying to solve the error message 'incompatible ranks 0 and 1 in assignment' in a fortran 95 program. -

-
i writing program in fortran find velocity of parachuting person in relation time. keep getting error can't fix. new programming , appreciated. the error is v(i+1)=v(i)+[32-((c*v(i)*v(i))/m)]*(h) 1 error: incompatible ranks 0 , 1 in assignment @ (1) and program is program para integer :: real :: v(11) !velocity real :: q !initial velocity real :: h !time step real :: c !drag coefficient real :: m !mass ! gravity equal 32 ft/s^2 write (*,*)'enter time step' read(*,*)h write(*,*)'enter initial velocity' read(*,*)q write(*,*)'enter drag coefficient' read(*,*)c write(*,*)'enter mass' read(*,*)m i=1,10 ! 1 10, 1 being interval. end v(i+1)=v(i)+[32-((c*v(i)*v(i))/m)]*(h) q=v(1) end program you cannot use [] normal parenthesis in expressions. array constructor, [ items ] means array items elements. end do should after line.
Read more